View: BIM_DIMV_TARGET_SGMTS

Product:	BIM - Marketing Intelligence(Obsolete)
Description:	Shows all target segments.
Implementation/DBA Data:	APPS.BIM_DIMV_TARGET_SGMTS

View Text

SELECT TO_CHAR(AMC.CELL_ID)
, SUBSTR(AMC.CELL_NAME
, 1
, 80)
, AMC.CELL_ID TARGET_SEGMENT_ID
, AMC.CELL_CODE TARGET_SEGMENT_CODE
, AMC.CELL_NAME TARGET_SEGMENT_NAME
, AMC.DESCRIPTION DESCRIPTION
, AMC.ORIGINAL_SIZE ORIGINAL_SIZE
, AMC.PARENT_CELL_ID PARENT_TARGET_SEGMENT_ID
, AMC.ENABLED_FLAG ENABLED_FLAG
FROM AMS_CELLS_VL AMC
WHERE AMC.MARKET_SEGMENT_FLAG <> 'Y' UNION ALL SELECT '-999'
, MEANING
, -999
, MEANING
, MEANING
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY

Columns