VIEW: APPS.CE_CP_DISC_XTO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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