View: AMS_LOOKUP_SALES_V

Product:	AMS - Marketing
Description:	This view is used by Discoverer Business Area:List generation LOV folders.
Implementation/DBA Data:	APPS.AMS_LOOKUP_SALES_V

View Text

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

Columns