View: CE_CP_ARR_V

Product:	CE - Cash Management
Description:	Cash Positioning source for Discoverer - AR Receipts
Implementation/DBA Data:	APPS.CE_CP_ARR_V

View Text

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

Columns