Cash Receipts Distribution info

Hi All,

I need to write a query to fetch the Receipts Distributions data. I have written the below query but it has duplicate records.

I am confused with the link between ar_misc_cash_distributions_all and ar_Cash_Receipts_history_All . Please can someone help.

SELECT cr.cash_Receipt_id "Receipt_id",

       hou1.name "Operating_unit",

       gcc.segment1 "Company",

       cr.doc_Sequence_value "Document_Number",

       cr.comments "Comments",

       TO_CHAR (acrha_current.trx_Date, 'DD-MON-YYYY') "Statement_Date",

       art.name "Activity",

       cr.receipt_number "Receipt_Number",

       al_status.meaning "State",

       acrha_first.status,

       TO_CHAR (cr.receipt_Date, 'DD-MON-YYYY') "Receipt_Date",