VIEW: APPS.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, ba.BANK_CODE, 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, at.USER_AMOUNT_TYPE, dda.TRANSACTION_NUMBER, dda.DEALER_CODE, dda.SETTLE, dda.DEAL_TYPE, dda.MULTIPLE_SETTLEMENTS from XTR_DEAL_DATE_AMOUNTS dda, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st, XTR_AMOUNT_TYPES at, XTR_BANK_ACCOUNTS ba WHERE dda.STATUS_CODE <> 'CANCELLED' and dda.CASHFLOW_AMOUNT <> 0 and dda.DEAL_TYPE <> 'CA' 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 (at.DEAL_TYPE = dda.DEAL_TYPE and at.AMOUNT_TYPE = dda.AMOUNT_TYPE) and ba.ACCOUNT_NUMBER (+) = dda.ACCOUNT_NO and ba.PARTY_CODE (+) = dda.COMPANY_CODE and ba.CURRENCY (+) = dda.CURRENCY

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
, BA.BANK_CODE
, 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
, AT.USER_AMOUNT_TYPE
, DDA.TRANSACTION_NUMBER
, DDA.DEALER_CODE
, DDA.SETTLE
, DDA.DEAL_TYPE
, DDA.MULTIPLE_SETTLEMENTS
FROM XTR_DEAL_DATE_AMOUNTS DDA
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_AMOUNT_TYPES AT
, XTR_BANK_ACCOUNTS BA
WHERE DDA.STATUS_CODE <> 'CANCELLED'
AND DDA.CASHFLOW_AMOUNT <> 0
AND DDA.DEAL_TYPE <> 'CA'
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 (AT.DEAL_TYPE = DDA.DEAL_TYPE
AND AT.AMOUNT_TYPE = DDA.AMOUNT_TYPE)
AND BA.ACCOUNT_NUMBER (+) = DDA.ACCOUNT_NO
AND BA.PARTY_CODE (+) = DDA.COMPANY_CODE
AND BA.CURRENCY (+) = DDA.CURRENCY