View: CE_CP_DISC_XTO_V

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

View Text

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

Columns