SELECT MSEG.MARKET_SEGMENT_ID , MSEG.ACT_MARKET_SEGMENT_USED_BY_ID CAMPAIGN_ID FROM AMS_ACT_MARKET_SEGMENTS MSEG , AMS_TERR_V TERR WHERE MSEG.MARKET_SEGMENT_ID = TERR.NODE_ID AND MSEG.SEGMENT_TYPE = TO_CHAR(TERR.HIERARCHY_LEVEL_ID) AND MSEG.ARC_ACT_MARKET_SEGMENT_USED_BY = 'CAMP' UNION ALL SELECT CELL.CELL_ID MARKET_SEGMENT_ID , MSEG.ACT_MARKET_SEGMENT_USED_BY_ID CAMPAIGN_ID FROM AMS_ACT_MARKET_SEGMENTS MSEG , AMS_CELLS_VL CELL WHERE MSEG.MARKET_SEGMENT_ID = CELL.CELL_ID AND MSEG.ARC_ACT_MARKET_SEGMENT_USED_BY = 'CAMP' UNION ALL SELECT MSEG.MARKET_SEGMENT_ID , MSEG.ACT_MARKET_SEGMENT_USED_BY_ID CAMPAIGN_ID FROM AMS_ACT_MARKET_SEGMENTS MSEG , AMS_GEOAREA_SCR_V GEOA WHERE MSEG.MARKET_SEGMENT_ID = GEOA.LOCATION_HIERARCHY_ID AND MSEG.ARC_ACT_MARKET_SEGMENT_USED_BY = 'CAMP'