GL Code Combination Id & Description

1)
SELECT
GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3
 ACCOUNT,
A1.DESCRIPTION||'-'||A2.DESCRIPTION ||'-'|| A3.DESCRIPTION  DECS
FROM
FND_FLEX_VALUES_VL A1,
FND_FLEX_VALUES_VL A2,
FND_FLEX_VALUES_VL A3,
GL_CODE_COMBINATIONS GCC
WHERE
A1.FLEX_VALUE=GCC.SEGMENT1
AND A1.FLEX_VALUE_SET_ID IN ( SELECT FLEX_VALUE_SET_ID
                            FROM FND_ID_FLEX_SEGMENTS
                           WHERE APPLICATION_ID = 101 AND ID_FLEX_CODE = 'GL#' AND ENABLED_FLAG = 'Y'
                           AND APPLICATION_COLUMN_NAME='SEGMENT1' )
AND A2.FLEX_VALUE=GCC.SEGMENT2
AND A2.FLEX_VALUE_SET_ID IN ( SELECT FLEX_VALUE_SET_ID
                            FROM FND_ID_FLEX_SEGMENTS
                           WHERE APPLICATION_ID = 101 AND ID_FLEX_CODE = 'GL#' AND ENABLED_FLAG = 'Y'
                           AND APPLICATION_COLUMN_NAME='SEGMENT2' )
AND A3.FLEX_VALUE=GCC.SEGMENT3
AND A3.FLEX_VALUE_SET_ID IN ( SELECT FLEX_VALUE_SET_ID
                            FROM FND_ID_FLEX_SEGMENTS
                           WHERE APPLICATION_ID = 101 AND ID_FLEX_CODE = 'GL#' AND ENABLED_FLAG = 'Y'
                           AND APPLICATION_COLUMN_NAME='SEGMENT3' )


2)  ---ONLY IN R12----
SELECT GCC.CONCATENATED_SEGMENTS,
GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION( GCC.CHART_OF_ACCOUNTS_ID, GCC.CODE_COMBINATION_ID) ACC_DESCRIPTION
FROM GL_CODE_COMBINATIONS_KFV GCC