VIEW: APPS.AMS_LOOKUP_SALES_V

Source

View Text - Preformatted

SELECT 'AR' category , LOOKUP_TYPE , LOOKUP_CODE code , MEANING description FROM AR_LOOKUPS WHERE ENABLED_FLAG = 'Y' UNION SELECT 'AS' category , LOOKUP_TYPE , LOOKUP_CODE code , MEANING description FROM AS_LOOKUPS WHERE ENABLED_FLAG = 'Y' UNION SELECT 'SO' category , LOOKUP_TYPE , lOOKUP_CODE code , MEANING description FROM SO_LOOKUPS WHERE enabled_flag = 'Y' UNION SELECT null category ,'COUNTRY' lookup_type , territory_code code, TERRITORY_SHORT_NAME description FROM fnd_territories_vl UNION SELECT 'FLEX' category , a.FLEX_VALUE_SET_NAME lookup_type , FLEX_VALUE code , FLEX_VALUE description FROM FND_FLEX_VALUE_SETS a ,FND_FLEX_VALUES b WHERE a.FLEX_VALUE_SET_ID = b.FLEX_VALUE_SET_ID AND b.ENABLED_FLAG = 'Y' UNION SELECT null category ,'WIN_PROBABILITY' lookup_type , to_char(prob.probability_value) code , prob.MEANING description FROM as_forecast_prob_all_vl prob ,ams_user_org_v usr WHERE upper(prob.enabled_flag) = 'Y' AND trunc(sysdate) between nvl(prob.start_date_active, trunc(sysdate) ) AND nvl(prob.end_date_active, trunc(sysdate) ) AND prob.org_id = usr.user_org_id AND prob.probability_value > -100 UNION SELECT null category ,'SALES_STAGE' lookup_type ,sstg.name code , sstg.DESCRIPTION description FROM as_sales_stages_all_vl sstg ,ams_user_org_v usr WHERE upper(sstg.enabled_flag) = 'Y' AND trunc(sysdate) BETWEEN nvl(sstg.start_date_active,trunc(sysdate)) AND nvl (sstg.end_date_active, trunc(sysdate)) AND sstg.org_id = usr.user_org_id AND sstg.SALES_STAGE_ID > 0

View Text - HTML Formatted

SELECT 'AR' CATEGORY
, LOOKUP_TYPE
, LOOKUP_CODE CODE
, MEANING DESCRIPTION
FROM AR_LOOKUPS
WHERE ENABLED_FLAG = 'Y' UNION SELECT 'AS' CATEGORY
, LOOKUP_TYPE
, LOOKUP_CODE CODE
, MEANING DESCRIPTION
FROM AS_LOOKUPS
WHERE ENABLED_FLAG = 'Y' UNION SELECT 'SO' CATEGORY
, LOOKUP_TYPE
, LOOKUP_CODE CODE
, MEANING DESCRIPTION
FROM SO_LOOKUPS
WHERE ENABLED_FLAG = 'Y' UNION SELECT NULL CATEGORY
, 'COUNTRY' LOOKUP_TYPE
, TERRITORY_CODE CODE
, TERRITORY_SHORT_NAME DESCRIPTION
FROM FND_TERRITORIES_VL UNION SELECT 'FLEX' CATEGORY
, A.FLEX_VALUE_SET_NAME LOOKUP_TYPE
, FLEX_VALUE CODE
, FLEX_VALUE DESCRIPTION
FROM FND_FLEX_VALUE_SETS A
, FND_FLEX_VALUES B
WHERE A.FLEX_VALUE_SET_ID = B.FLEX_VALUE_SET_ID
AND B.ENABLED_FLAG = 'Y' UNION SELECT NULL CATEGORY
, 'WIN_PROBABILITY' LOOKUP_TYPE
, TO_CHAR(PROB.PROBABILITY_VALUE) CODE
, PROB.MEANING DESCRIPTION
FROM AS_FORECAST_PROB_ALL_VL PROB
, AMS_USER_ORG_V USR
WHERE UPPER(PROB.ENABLED_FLAG) = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(PROB.START_DATE_ACTIVE
, TRUNC(SYSDATE) )
AND NVL(PROB.END_DATE_ACTIVE
, TRUNC(SYSDATE) )
AND PROB.ORG_ID = USR.USER_ORG_ID
AND PROB.PROBABILITY_VALUE > -100 UNION SELECT NULL CATEGORY
, 'SALES_STAGE' LOOKUP_TYPE
, SSTG.NAME CODE
, SSTG.DESCRIPTION DESCRIPTION
FROM AS_SALES_STAGES_ALL_VL SSTG
, AMS_USER_ORG_V USR
WHERE UPPER(SSTG.ENABLED_FLAG) = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(SSTG.START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL (SSTG.END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND SSTG.ORG_ID = USR.USER_ORG_ID
AND SSTG.SALES_STAGE_ID > 0