Product: | XTR - Treasury |
---|---|
Description: | Internal Treasury and external cashflows |
Implementation/DBA Data: | APPS.XTR_CASHFLOWS_V |
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