[Home] [Help]
View: XTR_CANCELLED_TRANSACTIONS_V
View Text
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)
Columns
Name |
DEAL_NUM |
TRANS_NUM |
CPARTY_CODE |
CLIENT_CODE |
COMPANY_CODE |
DEAL_TYPE |
USER_DEAL_TYPE |
DEAL_SUBTYPE |
USER_DEAL_SUBTYPE |
PRODUCT_TYPE |
DEAL_DATE |
CURRENCY |
UPDATED_BY |
UPDATED_ON |