VIEW: APPS.XTR_JOURNAL_COMBINATIONS_V

Source

View Text - Preformatted

SELECT distinct a.COMPANY_CODE, a.DEAL_TYPE, dt.USER_DEAL_TYPE, a.DEAL_SUBTYPE, st.USER_DEAL_SUBTYPE, a.PRODUCT_TYPE, a.PORTFOLIO_CODE from XTR_JOURNAL_ENTRY_ACTIONS a, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st where 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.COMPANY_CODE
, A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE
, A.PORTFOLIO_CODE
FROM XTR_JOURNAL_ENTRY_ACTIONS A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
WHERE A.DEAL_TYPE = DT.DEAL_TYPE
AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE)