eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XTR_REVIEW_CASH_CONSOL_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
DEAL_TYPE
USER_DEAL_TYPE
DEAL_NUMBER
COMPANY_CODE
CPARTY_CODE
CLIENT_CODE
PRODUCT_TYPE
MATURITY_DATE
CURRENCY
SECURITY_TYPE
INTEREST_SETTLEMENT_TYPE
BROKERAGE_CODE
BROKERAGE_RATE
INTEREST_FREQ
DEAL_SUBTYPE
USER_DEAL_SUBTYPE
PORTFOLIO_CODE
TAX_CODE