View: CE_XTR_CASHFLOWS_V

Product:	CE - Cash Management
Description:	Forecasting source - treasury
Implementation/DBA Data:	APPS.CE_XTR_CASHFLOWS_V

View Text

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.BANK_ACCOUNT_NUM = DDA.ACCOUNT_NO AND DDA.AMOUNT_TYPE = AT.AMOUNT_TYPE
AND DT.DEAL_TYPE = AT.DEAL_TYPE

Columns