View: BIC_MARKET_SEGMENT_V

Product:	BIC - Customer Intelligence (obsolete)
Description:	This view gets market segments from view ams_cells_vl.
Implementation/DBA Data:	APPS.BIC_MARKET_SEGMENT_V

View Text

SELECT TO_CHAR(CELL_ID) ID
, CELL_NAME VALUE
, 'ALL' ALL_FK
, CELL_ID MARKET_SEGMENT_ID
, CELL_CODE MARKET_SEGMENT_CODE
, CELL_NAME MARKET_SEGMENT_NAME
FROM AMS_CELLS_VL
WHERE MARKET_SEGMENT_FLAG = 'Y'
AND ENABLED_FLAG = 'Y' WITH READ ONLY

Columns