VIEW: APPS.CE_XTR_CASHFLOWS_V

Source

View Text - Preformatted

SELECT dda.DEAL_NUMBER, dda.DEAL_TYPE, dda.DEAL_SUBTYPE, dda.TRANSACTION_RATE, dda.STATUS_CODE, dda.CURRENCY, nvl(dda.ACTUAL_SETTLEMENT_DATE,dda.AMOUNT_DATE), dda.CASHFLOW_AMOUNT, dda.COMPANY_CODE, dda.ACCOUNT_NO, dda.PRODUCT_TYPE, dda.PORTFOLIO_CODE, dda.CPARTY_CODE, dda.CLIENT_CODE, dt.USER_DEAL_TYPE, dt.FX_MM_EXP_FLAG, st.USER_DEAL_SUBTYPE, dda.AMOUNT_TYPE, dda.TRANSACTION_NUMBER, dda.DEALER_CODE, dda.SETTLE, dda.DEAL_TYPE, p.SET_OF_BOOKS_ID, dda.MULTIPLE_SETTLEMENTS, dda.RECONCILED_REFERENCE, dt.NAME, st.NAME, p1.FULL_NAME, at.AMOUNT_NAME, p.LEGAL_ENTITY_ID, ba.BANK_ACCOUNT_ID, dda.DEAL_DATE_AMOUNT_ID from XTR_DEAL_DATE_AMOUNTS dda, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st, XTR_PARTY_INFO p, XTR_PARTY_INFO p1, CE_BANK_ACCTS_GT_V ba, XTR_AMOUNT_TYPES at WHERE dda.STATUS_CODE <> 'CANCELLED' and dda.CASHFLOW_AMOUNT <> 0 and nvl(dda.MULTIPLE_SETTLEMENTS,'N') = 'N' and dt.DEAL_TYPE = dda.DEAL_TYPE and (st.DEAL_TYPE = dda.DEAL_TYPE and st.DEAL_SUBTYPE = dda.DEAL_SUBTYPE) and p.PARTY_CODE(+) = dda.COMPANY_CODE and p1.PARTY_CODE(+) = dda.CPARTY_CODE and ba.account_owner_org_id (+) = p.legal_entity_id and ba.CURRENCY_CODE = dda.CURRENCY and ba.xtr_bank_account_reference = dda.account_no and dda.AMOUNT_TYPE = at.AMOUNT_TYPE and dt.DEAL_TYPE = at.DEAL_TYPE

View Text - HTML Formatted

SELECT DDA.DEAL_NUMBER
, DDA.DEAL_TYPE
, DDA.DEAL_SUBTYPE
, DDA.TRANSACTION_RATE
, DDA.STATUS_CODE
, DDA.CURRENCY
, NVL(DDA.ACTUAL_SETTLEMENT_DATE
, DDA.AMOUNT_DATE)
, DDA.CASHFLOW_AMOUNT
, DDA.COMPANY_CODE
, DDA.ACCOUNT_NO
, DDA.PRODUCT_TYPE
, DDA.PORTFOLIO_CODE
, DDA.CPARTY_CODE
, DDA.CLIENT_CODE
, DT.USER_DEAL_TYPE
, DT.FX_MM_EXP_FLAG
, ST.USER_DEAL_SUBTYPE
, DDA.AMOUNT_TYPE
, DDA.TRANSACTION_NUMBER
, DDA.DEALER_CODE
, DDA.SETTLE
, DDA.DEAL_TYPE
, P.SET_OF_BOOKS_ID
, DDA.MULTIPLE_SETTLEMENTS
, DDA.RECONCILED_REFERENCE
, DT.NAME
, ST.NAME
, P1.FULL_NAME
, AT.AMOUNT_NAME
, P.LEGAL_ENTITY_ID
, BA.BANK_ACCOUNT_ID
, DDA.DEAL_DATE_AMOUNT_ID
FROM XTR_DEAL_DATE_AMOUNTS DDA
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_PARTY_INFO P
, XTR_PARTY_INFO P1
, CE_BANK_ACCTS_GT_V BA
, XTR_AMOUNT_TYPES AT
WHERE DDA.STATUS_CODE <> 'CANCELLED'
AND DDA.CASHFLOW_AMOUNT <> 0
AND NVL(DDA.MULTIPLE_SETTLEMENTS
, 'N') = 'N'
AND DT.DEAL_TYPE = DDA.DEAL_TYPE
AND (ST.DEAL_TYPE = DDA.DEAL_TYPE
AND ST.DEAL_SUBTYPE = DDA.DEAL_SUBTYPE)
AND P.PARTY_CODE(+) = DDA.COMPANY_CODE
AND P1.PARTY_CODE(+) = DDA.CPARTY_CODE
AND BA.ACCOUNT_OWNER_ORG_ID (+) = P.LEGAL_ENTITY_ID
AND BA.CURRENCY_CODE = DDA.CURRENCY
AND BA.XTR_BANK_ACCOUNT_REFERENCE = DDA.ACCOUNT_NO
AND DDA.AMOUNT_TYPE = AT.AMOUNT_TYPE
AND DT.DEAL_TYPE = AT.DEAL_TYPE