VIEW: APPS.CE_CP_XTO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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