VIEW: APPS.CE_CP_DISC_XTI_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))