View: AMS_EVENT_MARKET_SEGMENTS_V

Product:	AMS - Marketing
Description:	This view returns the general information about market segments associated with events.
Implementation/DBA Data:	APPS.AMS_EVENT_MARKET_SEGMENTS_V

View Text

SELECT AAMS.ACTIVITY_MARKET_SEGMENT_ID
, AAMS.ACT_MARKET_SEGMENT_USED_BY_ID
, AAMS.ARC_ACT_MARKET_SEGMENT_USED_BY
, AAMS.MARKET_SEGMENT_ID
, AC.CELL_NAME
, AC.DESCRIPTION
, AC.MARKET_SEGMENT_FLAG
, AC.ORIGINAL_SIZE
FROM AMS_ACT_MARKET_SEGMENTS AAMS
, AMS_CELLS_VL AC
WHERE AAMS.MARKET_SEGMENT_ID = AC.CELL_ID

Columns