VIEW: APPS.CE_CP_ARR_V

Source

View Text - Preformatted

SELECT CR.cash_receipt_id, CR.remittance_bank_account_id, nvl(CR.actual_value_date, nvl(APS.due_date, CRH.trx_date)), CR.actual_value_date, APS.due_date, CRH.trx_date, CR.receipt_number, CRH.acctd_amount, CRH.status, CR.receipt_method_id FROM AR_CASH_RECEIPTS_ALL CR, AR_CASH_RECEIPT_HISTORY_ALL CRH, AR_PAYMENT_SCHEDULES_ALL APS WHERE CR.cash_receipt_id = CRH.cash_receipt_id AND (APS.org_id = CRH.org_id OR APS.org_id IS NULL) AND APS.cash_receipt_id(+) = CRH.cash_receipt_id AND (CRH.org_id = CR.org_id OR CRH.org_id IS NULL) AND CRH.current_record_flag = 'Y' AND CRH.status != 'REVERSED' AND CRH.reversal_gl_date IS NULL

View Text - HTML Formatted

SELECT CR.CASH_RECEIPT_ID
, CR.REMITTANCE_BANK_ACCOUNT_ID
, NVL(CR.ACTUAL_VALUE_DATE
, NVL(APS.DUE_DATE
, CRH.TRX_DATE))
, CR.ACTUAL_VALUE_DATE
, APS.DUE_DATE
, CRH.TRX_DATE
, CR.RECEIPT_NUMBER
, CRH.ACCTD_AMOUNT
, CRH.STATUS
, CR.RECEIPT_METHOD_ID
FROM AR_CASH_RECEIPTS_ALL CR
, AR_CASH_RECEIPT_HISTORY_ALL CRH
, AR_PAYMENT_SCHEDULES_ALL APS
WHERE CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
AND (APS.ORG_ID = CRH.ORG_ID OR APS.ORG_ID IS NULL)
AND APS.CASH_RECEIPT_ID(+) = CRH.CASH_RECEIPT_ID
AND (CRH.ORG_ID = CR.ORG_ID OR CRH.ORG_ID IS NULL)
AND CRH.CURRENT_RECORD_FLAG = 'Y'
AND CRH.STATUS != 'REVERSED'
AND CRH.REVERSAL_GL_DATE IS NULL