VIEW: APPS.XTR_TY_SUB_PRD_COMBIN_V

Source

View Text - Preformatted

SELECT distinct a.DEAL_TYPE, dt.USER_DEAL_TYPE, a.DEAL_SUBTYPE, st.USER_DEAL_SUBTYPE, a.PRODUCT_TYPE from XTR_AUTH_TYPE_SUBTYPE_PROD a, XTR_DEAL_TYPES dt, XTR_DEAL_SUBTYPES st where a.AUTHORISED = 'Y' and a.USER_NAME in (select b.DEALER_CODE from XTR_DEALER_CODES b where b.USER_ID = FND_GLOBAL.USER_ID) 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.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE
FROM XTR_AUTH_TYPE_SUBTYPE_PROD A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
WHERE A.AUTHORISED = 'Y'
AND A.USER_NAME IN (SELECT B.DEALER_CODE
FROM XTR_DEALER_CODES B
WHERE B.USER_ID = FND_GLOBAL.USER_ID)
AND A.DEAL_TYPE = DT.DEAL_TYPE
AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE)