View: XTR_DDA_EXPOSURES_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_DDA_EXPOSURES_V

View Text

SELECT A.DEAL_NUMBER
, A.TRANSACTION_NUMBER
, NVL(A.ACTUAL_SETTLEMENT_DATE
, A.AMOUNT_DATE) 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.SETTLE
, A.CPARTY_ACCOUNT_NO CPARTY_ACCOUNT
, A.DIRECT_DEBIT
, A.CHQ_REQD
, A.COMMENTS
, A.ACTION_CODE
, AC.USER_ACTION_CODE
, A.ATTACHMENT_EXISTS
, CURRENCY_COMBINATION
, A.BENEFICIARY_PARTY
, A.BENEFICIARY_ACCOUNT_NO BENEFICIARY_ACCOUNT
, A.BALANCE_SHEET_EXPOSURE
, A.EXPOSURE_REF_DATE FROM XTR_DEAL_DATE_AMOUNTS_V A
, XTR_PARTIES_V P
, XTR_PARTIES_V Q
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_AMOUNT_TYPES AT
, XTR_DEAL_STATUSES DS
, XTR_AMOUNT_ACTIONS AC WHERE A.CASHFLOW_AMOUNT <> 0
AND A.AMOUNT_TYPE NOT IN('FXOBUY'
, 'FXOSELL')
AND NVL(A.MULTIPLE_SETTLEMENTS
, 'N') = 'N'
AND A.STATUS_CODE <> 'CANCELLED'
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 = AC.DEAL_TYPE (+)
AND A.AMOUNT_TYPE = AC.AMOUNT_TYPE (+)
AND A.ACTION_CODE = AC.ACTION_CODE (+) )

Columns