VIEW: APPS.XTR_DDA_EXPOSURES_V

Source

View Text - Preformatted

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 (+) )

View Text - HTML Formatted

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 (+) )