SELECT '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' UNION ALL SELECT 'ALL' ALL_FK , -999 MARKET_SEGMENT_ID , MEANING MARKET_SEGMENT_CODE , MEANING MARKET_SEGMENT_NAME FROM FND_LOOKUPS FL WHERE FL.LOOKUP_TYPE = 'BIC_VALUE_TYPE' AND FL.LOOKUP_CODE = '-999' WITH READ ONLY