View: CE_CP_XTO_V

Product:	CE - Cash Management
Description:	Cash Positioning source for Discoverer - Treasury Inflow
Implementation/DBA Data:	APPS.CE_CP_XTO_V

View Text

SELECT DDA.DEAL_DATE_AMOUNT_ID
, CBA.BANK_ACCOUNT_ID
, NVL(DDA.ACTUAL_SETTLEMENT_DATE
, DDA.AMOUNT_DATE)
, DDA.DEAL_NUMBER
, DDA.CASHFLOW_AMOUNT
, DECODE(DDA.DEAL_TYPE
, 'EXP'
, DECODE(DDA.DEAL_SUBTYPE
, 'INDIC'
, 'Y'
, 'N')
, 'N')
, DDA.DEAL_TYPE
, DDA.RECONCILED_REFERENCE FROM XTR_DEAL_DATE_AMOUNTS DDA
, CE_BANK_ACCTS_GT_V CBA
, XTR_PARTY_INFO XP
WHERE DDA.STATUS_CODE <> 'CANCELLED' AND DDA.CASHFLOW_AMOUNT < 0 AND NVL(DDA.MULTIPLE_SETTLEMENTS
, 'N') = 'N' AND XP.LEGAL_ENTITY_ID = CBA.ACCOUNT_OWNER_ORG_ID AND XP.PARTY_CODE(+) = DDA.COMPANY_CODE AND CBA.CURRENCY_CODE(+) = DDA.CURRENCY AND CBA.BANK_ACCOUNT_NUM(+) = DDA.ACCOUNT_NO

Columns