SELECT SEGMENT_NAME , APPLICATION_COLUMN_NAME , ID_FLEX_NUM FROM FND_ID_FLEX_SEGMENTS SEG WHERE ENABLED_FLAG = 'Y' AND ID_FLEX_CODE = 'GL#' AND APPLICATION_ID = 101 AND EXISTS( SELECT COLUMN_NAME FROM ALL_IND_COLUMNS COLS WHERE SEG.APPLICATION_COLUMN_NAME = COLS.COLUMN_NAME AND COLS.COLUMN_POSITION = 1 AND COLS.TABLE_NAME = 'GL_CODE_COMBINATIONS')