--===========================================
--Real Time Requirement
--Report Name: Credit Hold and Past Due Risk Report
--Module: Oracle Fusion Financials (AR)
--============================================
Customer_Name
Party_ID
Customer_Account_Id
Customer_Account_Profile_Id
Account_Number
Account_Description
PROFILE_CLASS_ID
Profile_Class_Name
Account_Last_Updated_By
Account_Last_Update_Date
Credit_Hold
Credit_Hold_Last_Updated_By
Credit_Hold_Last_Update_Date
Registry_Id
Relationship_parent_child_
Account_Hierarchy
Related_Name
Oldest_Due_Date
Past_Due_Days
Past_Due_Balance
From_Date
To_Date
Account_Status
----------------------------
Optional Parameters:
Registry Id & Account Number
------------------------------
Output format: CSV/XML/Excel
-----------------------------
Logics: Need to display Parent and Child Accounts in the same field.
Means Need to follow the hierarcy Registry ID-->Parent-->Childs.
If parent account as on-hold then related child accounts also be on-hold.Past due days(>=32)
If parent or child account has credit hold then related all the accounts should be on-hold.Past due days(>=32)
If any account releases manually(i.e .com or system) then it account status should go release.
Filter only Core Customers
