View: BIM_DIMV_MARKET_SGMTS

Product:	BIM - Marketing Intelligence
Description:	Shows all market segments.
Implementation/DBA Data:	APPS.BIM_DIMV_MARKET_SGMTS

View Text

SELECT AMC.CELL_ID MARKET_SEGMENT_ID
, AMC.CELL_CODE MARKET_SEGMENT_CODE
, AMC.ORIGINAL_SIZE MARKET_SEGMENT_ORIGINAL_SIZE
, AMC.ENABLED_FLAG ENABLED_FLAG
, AMC.CELL_NAME MARKET_SEGMENT_NAME
, AMC.DESCRIPTION DESCRIPTION
FROM AMS_CELLS_VL AMC
WHERE AMC.MARKET_SEGMENT_FLAG = 'Y' ORDER BY 2
, 5 UNION ALL SELECT -999
, NULL
, TO_NUMBER(NULL)
, NULL
, MEANING
, NULL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY

Columns