VIEW: APPS.XTR_TY_SUB_PRD_PORT_COMBIN_V

Source

View Text - Preformatted

SELECT a.DEAL_TYPE, dt.USER_DEAL_TYPE, a.DEAL_SUBTYPE, st.USER_DEAL_SUBTYPE, a.PRODUCT_TYPE, b.COMPANY_CODE, b.PORTFOLIO FROM (SELECT DISTINCT DEAL_TYPE, DEAL_SUBTYPE, PRODUCT_TYPE FROM XTR_AUTH_TYPE_SUBTYPE_PROD) a, XTR_PORTFOLIOS b, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st WHERE a.DEAL_TYPE = dt.DEAL_TYPE AND dt.DEAL_TYPE <> 'CA' AND a.DEAL_TYPE = st.DEAL_TYPE AND a.DEAL_SUBTYPE = st.DEAL_SUBTYPE UNION ALL SELECT dt.DEAL_TYPE, dt.USER_DEAL_TYPE, st.DEAL_SUBTYPE, st.USER_DEAL_SUBTYPE, 'NOT APPLIC', b.COMPANY_CODE, b.PORTFOLIO FROM XTR_PORTFOLIOS b, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st WHERE dt.DEAL_TYPE = 'CA' AND dt.DEAL_TYPE = st.DEAL_TYPE

View Text - HTML Formatted

SELECT A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE
, B.COMPANY_CODE
, B.PORTFOLIO
FROM (SELECT DISTINCT DEAL_TYPE
, DEAL_SUBTYPE
, PRODUCT_TYPE
FROM XTR_AUTH_TYPE_SUBTYPE_PROD) A
, XTR_PORTFOLIOS B
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
WHERE A.DEAL_TYPE = DT.DEAL_TYPE
AND DT.DEAL_TYPE <> 'CA'
AND A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE UNION ALL SELECT DT.DEAL_TYPE
, DT.USER_DEAL_TYPE
, ST.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, 'NOT APPLIC'
, B.COMPANY_CODE
, B.PORTFOLIO
FROM XTR_PORTFOLIOS B
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
WHERE DT.DEAL_TYPE = 'CA'
AND DT.DEAL_TYPE = ST.DEAL_TYPE