Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_NUMBER
, A.COMPANY_CODE
, A.CPARTY_CODE
, A.CLIENT_CODE
, A.PRODUCT_TYPE
, A.MATURITY_DATE
, A.CURRENCY
, A.SECURITY_TYPE
, A.INTEREST_SETTLEMENT_TYPE
, A.BROKERAGE_CODE
, A.BROKERAGE_RATE
, A.INTEREST_FREQ
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PORTFOLIO_CODE
, A.TAX_CODE FROM XTR_ROLLOVER_TRANSACTIONS_V A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST WHERE A.STATUS_CODE = 'CURRENT' AND A.DEAL_TYPE = DT.DEAL_TYPE AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE) GROUP BY A.DEAL_TYPE
, A.DEAL_NUMBER
, A.COMPANY_CODE
, A.PORTFOLIO_CODE
, A.CPARTY_CODE
, A.CLIENT_CODE
, A.CURRENCY
, A.SECURITY_TYPE
, A.PRODUCT_TYPE
, A.MATURITY_DATE
, A.INTEREST_SETTLEMENT_TYPE
, A.BROKERAGE_CODE
, A.BROKERAGE_RATE
, A.INTEREST_FREQ
, A.DEAL_SUBTYPE
, A.PORTFOLIO_CODE
, A.TAX_CODE
, DT.USER_DEAL_TYPE
, ST.USER_DEAL_SUBTYPE