SELECT DISTINCT VAL.FLEX_MAPPING_SET_ID , VAL.APPLICATION_COLUMN_NAME , SEG.SEGMENT_NAME , SEG.ID_FLEX_NUM , VAL.FLEX_VALUE_SET_ID FROM PSB_FLEX_MAPPING_SET_VALUES VAL , FND_ID_FLEX_SEGMENTS_VL SEG , PSB_FLEX_MAPPING_SETS SETS WHERE VAL.FLEX_MAPPING_SET_ID = SETS.FLEX_MAPPING_SET_ID AND SEG.APPLICATION_COLUMN_NAME = VAL.APPLICATION_COLUMN_NAME AND SEG.APPLICATION_ID = 101 AND SEG.ID_FLEX_CODE='GL#'