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
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
|
|
|