View: XTR_MATURITIES_V

Product:	XTR - Treasury
Description:	Cashflows belonging to only those date amount types relevant to the Tresaury maturity reports
Implementation/DBA Data:	APPS.XTR_MATURITIES_V

View Text

SELECT A.DEAL_NUMBER
, A.TRANSACTION_NUMBER
, A.AMOUNT_DATE
, A.CURRENCY
, A.AMOUNT_TYPE TYPE_OF_AMOUNT
, AT.USER_AMOUNT_TYPE
, A.AMOUNT
, A.CASHFLOW_AMOUNT
, A.COMPANY_CODE COMPANY
, A.CPARTY_CODE CPARTY
, P.SHORT_NAME CPARTY_NAME
, A.CLIENT_CODE CLIENT
, Q.SHORT_NAME CLIENT_NAME
, A.DEALER_CODE DEALER
, A.DEAL_TYPE CONTRACT_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE PRODUCT
, A.PORTFOLIO_CODE PORTFOLIO
, A.CODE_COMBINATION_ID
, A.TRANSACTION_RATE RATE
, A.ACCOUNT_NO COMPANY_ACCOUNT
, A.HCE_AMOUNT
, A.STATUS_CODE CONTRACT_STATUS
, DS.USER_STATUS_CODE
, A.DIARY_NOTE DIARY_NOTE_DETAILS
, A.DUAL_AUTHORISATION_BY AUTHORISED_BY
, A.DUAL_AUTHORISATION_ON AUTHORISED_ON
, A.DATE_TYPE
, DAT.USER_DATE_TYPE
FROM XTR_DEAL_DATE_AMOUNTS_V A
, XTR_PARTY_INFO P
, XTR_PARTY_INFO Q
, XTR_DATE_AMOUNT_TYPES D
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_AMOUNT_TYPES AT
, XTR_DEAL_STATUSES DS
, XTR_DATE_TYPES DAT
WHERE D.DEAL_TYPE = A.DEAL_TYPE
AND D.DATE_TYPE = A.DATE_TYPE
AND D.AMOUNT_TYPE = A.AMOUNT_TYPE
AND D.MATURITY_REPORT = 'Y'
AND A.CPARTY_CODE = P.PARTY_CODE (+)
AND A.CLIENT_CODE = Q.PARTY_CODE (+)
AND A.DEAL_TYPE = DT.DEAL_TYPE
AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE)
AND (A.DEAL_TYPE = AT.DEAL_TYPE
AND A.AMOUNT_TYPE = AT.AMOUNT_TYPE)
AND (A.DEAL_TYPE = DS.DEAL_TYPE
AND A.STATUS_CODE = DS.STATUS_CODE)
AND (A.DEAL_TYPE = DAT.DEAL_TYPE
AND A.DATE_TYPE = DAT.DATE_TYPE)

Columns