Query to get description of GL Code Combination

By Amol Jadhav
Query to get description of GL Code Combination
Oracle Apps EBS sql to get description of GL Code Combination
SQL Querysql
1SELECT GCC.CONCATENATED_SEGMENTS ACCOUNT,
2       GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION (GCC.CHART_OF_ACCOUNTS_ID,
3                                                 GCC.CODE_COMBINATION_ID)
4          DESCRIPTION
5  FROM GL_CODE_COMBINATIONS_KFV GCC
6 WHERE gcc.CODE_COMBINATION_ID = 2003

Related posts: