Product: | OKL - Leasing and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_RECEIPT_SUMMARY_UV |
SELECT ARCASH.CASH_RECEIPT_ID
, ARCASH.RECEIPT_NUMBER
, ARCASH.RECEIPT_DATE
, ARCASH.CURRENCY_CODE
, ARCASH.ORG_ID
, HR.NAME
, ARCASH.LEGAL_ENTITY_ID
, ARCASH.AMOUNT
, CRH.STATUS
, ARCASH.PAY_FROM_CUSTOMER
, HCA.ACCOUNT_NUMBER
, HZP.PARTY_NUMBER
, HZP.PARTY_NAME
, RM.NAME
, RM.RECEIPT_METHOD_ID
, CRH.GL_DATE
, DECODE(OKLRCPT.RECEIPT_TYPE
, 'ADV'
, OKLRCPT.RECEIPT_TYPE
, 'REG') RECEIPT_TYPE
FROM AR_CASH_RECEIPTS_ALL ARCASH
, HZ_CUST_ACCOUNTS_ALL HCA
, HZ_PARTIES HZP
, AR_RECEIPT_METHODS RM
, HR_OPERATING_UNITS HR
, AR_CASH_RECEIPT_HISTORY_ALL CRH
, OKL_TRX_CSH_RCPT_ALL_B OKLRCPT
WHERE ARCASH.PAY_FROM_CUSTOMER = HCA.CUST_ACCOUNT_ID(+)
AND HCA.PARTY_ID = HZP.PARTY_ID(+)
AND ARCASH.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
AND ARCASH.ORG_ID = HR.ORGANIZATION_ID
AND ARCASH.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
AND CRH.CURRENT_RECORD_FLAG = 'Y'
AND ARCASH.CASH_RECEIPT_ID = OKLRCPT.CASH_RECEIPT_ID(+)
AND OKLRCPT.RECEIPT_TYPE(+) = 'ADV'