[Home] [Help]
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
Name |
REFERENCE_ID |
BANK_ACCOUNT_ID |
CASH_ACTIVITY_DATE |
ACTUAL_VALUE_DATE |
MATURITY_DATE |
TRX_DATE |
RECEIPT_NUMBER |
BASE_AMOUNT |
STATUS |
RECEIPT_METHOD_ID |