VIEW: APPS.XTR_MATURITIES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)