[Home] [Help]
View: XTR_CASH_TRANSACTIONS_V
View Text
SELECT DISTINCT A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.COMPANY_CODE
, A.CPARTY_CODE
, A.CLIENT_CODE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.CURRENCY
, A.PRODUCT_TYPE
, A.SECURITY_TYPE
, A.PORTFOLIO_CODE FROM XTR_ROLLOVER_TRANSACTIONS_V A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST WHERE STATUS_CODE = 'CURRENT' AND A.DEAL_TYPE = DT.DEAL_TYPE AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE)
Columns
Name |
DEAL_TYPE |
USER_DEAL_TYPE |
COMPANY_CODE |
CPARTY_CODE |
CLIENT_CODE |
DEAL_SUBTYPE |
USER_DEAL_SUBTYPE |
CURRENCY |
PRODUCT_TYPE |
SECURITY_TYPE |
PORTFOLIO_CODE |