VIEW: APPS.XTR_CASH_TRANSACTIONS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)