AR Receipt

Dear All,

i want to create a query to select statement line & statement header from AR_CASH_RECEIPTS

query used:

SELECT

ARA.AMOUNT AR_AMOUNT,

ARA.RECEIPT_DATE AR_RECEIPT_DATE,

ARA.RECEIPT_NUMBER AR_RECEIPT_NUMBER,

CRH.status AR_status,

ARA.TYPE AR_type,

ARPT_SQL_FUNC_UTIL.get_lookup_meaning('RECEIPT_CREATION_STATUS',CRH_CURRENT.STATUS) STATE_DSP ,

CRH_CURRENT.STATUS STATE

FROM

ar_cash_receipts_all ARA,

CE_BANK_ACCOUNTS             CBA,

CE_BANK_BRANCHES_V           BB,

CE_BANK_ACCT_USES_ALL       REMIT_BANK,

AR_CASH_RECEIPT_HISTORY_ALL  CRH,

AR_CASH_RECEIPT_HISTORY_ALL CRH_CURRENT

WHERE