View: XTR_DISC_CASHFLOWS_V

Product:	XTR - Treasury
Description:	Internal Treasury and external cash flows, where useraccess to company information is enforced.
Implementation/DBA Data:	APPS.XTR_DISC_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
, 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
, DT.NAME DEAL_TYPE_NAME
, ST.NAME DEAL_SUBTYPE_NAME
, A.FULL_NAME COMPANY_FULL_NAME
, B.FULL_NAME CPARTY_FULL_NAME
, BA.BANK_NAME BANK_NAME
, AT.AMOUNT_NAME AMOUNT_TYPE_NAME
FROM XTR_DEAL_DATE_AMOUNTS DDA
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_AMOUNT_TYPES AT
, XTR_BANK_ACCOUNTS BA
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
, XTR_PARTY_INFO A
, XTR_PARTY_INFO B
WHERE DDA.COMPANY_CODE = A.PARTY_CODE
AND DDA.CPARTY_CODE = B.PARTY_CODE(+)
AND 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
AND DDA.COMPANY_CODE=XCA.PARTY_CODE
AND XCA.DEALER_CODE=XDC.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y'
AND XDC.USER_ID=FND_GLOBAL.USER_ID UNION ALL SELECT 0
, 'EXT'
, 'INDIC'
, 1
, 'CURRENT'
, EX.CURRENCY
, EX.AMOUNT_DATE
, DECODE(EX.TRX_TYPE
, 'ARI'
, EX.AMOUNT
, 'ARR'
, EX.AMOUNT
, 'OEO'
, EX.AMOUNT
, 'OII'
, EX.AMOUNT
, 'UDI'
, EX.AMOUNT
, 'API'
, -(EX.AMOUNT)
, 'APP'
, -(EX.AMOUNT)
, 'PAY'
, -(EX.AMOUNT)
, 'POP'
, -(EX.AMOUNT)
, 'POR'
, -(EX.AMOUNT)
, 'OIO'
, -(EX.AMOUNT)
, 'UDO'
, -(EX.AMOUNT)
, EX.AMOUNT)
, EX.COMPANY_CODE
, BA.ACCOUNT_NUMBER
, BA.BANK_CODE
, NULL
, NULL
, NULL
, NULL
, DT.USER_DEAL_TYPE
, 'XX'
, ST.USER_DEAL_SUBTYPE
, EX.TRX_TYPE
, AT.USER_AMOUNT_TYPE
, 0
, NULL
, 'N'
, 'EXT'
, 'N'
, DT.NAME DEAL_TYPE_NAME
, ST.NAME DEAL_SUBTYPE_NAME
, A.FULL_NAME COMPANY_FULL_NAME
, NULL CPARTY_FULL_NAME
, BA.BANK_NAME BANK_NAME
, AT.AMOUNT_NAME AMOUNT_TYPE_NAME
FROM XTR_EXTERNAL_CASHFLOWS EX
, XTR_BANK_ACCOUNTS BA
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_AMOUNT_TYPES AT
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
, XTR_PARTY_INFO A
WHERE EX.COMPANY_CODE = A.PARTY_CODE
AND DT.DEAL_TYPE = 'EXT'
AND EX.AP_BANK_ACCOUNT_ID = BA.AP_BANK_ACCOUNT_ID (+)
AND EX.CURRENCY = BA.CURRENCY (+)
AND EX.COMPANY_CODE = BA.PARTY_CODE (+)
AND (ST.DEAL_TYPE = 'EXT'
AND ST.DEAL_SUBTYPE = 'INDIC')
AND (AT.DEAL_TYPE = 'EXT'
AND AT.AMOUNT_TYPE = EX.TRX_TYPE)
AND EX.COMPANY_CODE=XCA.PARTY_CODE
AND XCA.DEALER_CODE=XDC.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y'
AND XDC.USER_ID=FND_GLOBAL.USER_ID

Columns