View: CE_CP_DISC_XTI_V

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

View Text

SELECT WSL.WORKSHEET_HEADER_ID
, XTI.BANK_ACCOUNT_ID
, WSL.WORKSHEET_LINE_ID
, WSL.DESCRIPTION
, TO_CHAR(XTI.DEAL_NUMBER)
, XTI.AMOUNT
, XTI.REFERENCE_ID FROM CE_XTR_CASHFLOWS_V XTI
, CE_CP_WORKSHEET_LINES WSL
WHERE XTI.TRX_DATE = TO_DATE(SYSDATE
, 'YYYY/MM/DD') AND WSL.SOURCE_TYPE = 'XTI' AND WSL.INCLUDE_FLAG = 'Y' AND XTI.AMOUNT >= 0 AND (WSL.CLEARED_TRX_FLAG = 'Y' OR XTI.RECONCILED_REFERENCE IS NULL) AND (WSL.INDICATIVE_FLAG = 'Y' OR NOT (XTI.DDA_DEAL_TYPE = 'EXP'
AND XTI.DDA_DEAL_SUBTYPE = 'INDIC'))

Columns