VIEW: APPS.XTR_CANCELLED_TRANSACTIONS_V

Source

View Text - Preformatted

SELECT rt.DEAL_NUMBER DEAL_NUM, rt.TRANSACTION_NUMBER TRANS_NUM, rt.CPARTY_CODE, rt.CLIENT_CODE, rt.COMPANY_CODE, rt.DEAL_TYPE, dt.USER_DEAL_TYPE, rt.DEAL_SUBTYPE, st.USER_DEAL_SUBTYPE, rt.PRODUCT_TYPE, rt.DEAL_DATE, rt.CURRENCY, rt.UPDATED_BY, rt.UPDATED_ON from XTR_ROLLOVER_TRANSACTIONS_V rt, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st where rt.DEAL_TYPE IN('ONC','CMF') and rt.STATUS_CODE = 'CANCELLED' AND rt.DEAL_TYPE = dt.DEAL_TYPE AND (rt.DEAL_TYPE = st.DEAL_TYPE AND rt.DEAL_SUBTYPE = st.DEAL_SUBTYPE) UNION ALL select d.DEAL_NO DEAL_NUM, d.TRANSACTION_NO TRANS_NUM, d.CPARTY_CODE, d.CLIENT_CODE, d.COMPANY_CODE, d.DEAL_TYPE, dt.USER_DEAL_TYPE, d.DEAL_SUBTYPE, st.USER_DEAL_SUBTYPE, d.PRODUCT_TYPE, d.DEAL_DATE, nvl(d.CURRENCY,d.CURRENCY_BUY), d.UPDATED_BY, d.UPDATED_ON from XTR_DEALS_V d, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st where d.DEAL_TYPE NOT IN('ONC','CMF') and d.STATUS_CODE = 'CANCELLED' AND d.DEAL_TYPE = dt.DEAL_TYPE AND (d.DEAL_TYPE = st.DEAL_TYPE AND d.DEAL_SUBTYPE = st.DEAL_SUBTYPE)

View Text - HTML Formatted

SELECT RT.DEAL_NUMBER DEAL_NUM
, RT.TRANSACTION_NUMBER TRANS_NUM
, RT.CPARTY_CODE
, RT.CLIENT_CODE
, RT.COMPANY_CODE
, RT.DEAL_TYPE
, DT.USER_DEAL_TYPE
, RT.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, RT.PRODUCT_TYPE
, RT.DEAL_DATE
, RT.CURRENCY
, RT.UPDATED_BY
, RT.UPDATED_ON
FROM XTR_ROLLOVER_TRANSACTIONS_V RT
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
WHERE RT.DEAL_TYPE IN('ONC'
, 'CMF')
AND RT.STATUS_CODE = 'CANCELLED'
AND RT.DEAL_TYPE = DT.DEAL_TYPE
AND (RT.DEAL_TYPE = ST.DEAL_TYPE
AND RT.DEAL_SUBTYPE = ST.DEAL_SUBTYPE) UNION ALL SELECT D.DEAL_NO DEAL_NUM
, D.TRANSACTION_NO TRANS_NUM
, D.CPARTY_CODE
, D.CLIENT_CODE
, D.COMPANY_CODE
, D.DEAL_TYPE
, DT.USER_DEAL_TYPE
, D.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, D.PRODUCT_TYPE
, D.DEAL_DATE
, NVL(D.CURRENCY
, D.CURRENCY_BUY)
, D.UPDATED_BY
, D.UPDATED_ON
FROM XTR_DEALS_V D
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
WHERE D.DEAL_TYPE NOT IN('ONC'
, 'CMF')
AND D.STATUS_CODE = 'CANCELLED'
AND D.DEAL_TYPE = DT.DEAL_TYPE
AND (D.DEAL_TYPE = ST.DEAL_TYPE
AND D.DEAL_SUBTYPE = ST.DEAL_SUBTYPE)