View: XTR_CASH_TRANSACTIONS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.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