SELECT GCC.CODE_COMBINATION_ID
,GL_FLEXFIELDS_PKG.GET_ACCOUNT_SEGMENT(GCC.CHART_OF_ACCOUNTS_ID) GET_ACCOUNT_SEGMENT
,GL_FLEXFIELDS_PKG.GET_COA_NAME(GCC.CHART_OF_ACCOUNTS_ID) GET_COA_NAME
,GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION(GCC.CHART_OF_ACCOUNTS_ID,GCC.CODE_COMBINATION_ID) GET_CONCAT_DESCRIPTION
,GCC.SEGMENT1
,GCC.SEGMENT2
,GCC.SEGMENT3
,GCC.SEGMENT4
,GCC.SEGMENT5
,GCC.SEGMENT6
,GCC.SEGMENT7
,GCC.SEGMENT8
,DECODE(GCC.SEGMENT1,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
(GCC.CHART_OF_ACCOUNTS_ID,1,GCC.SEGMENT1)) SEG1_DESC
,DECODE(GCC.SEGMENT2,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,2,GCC.SEGMENT2)) SEG2_DESC
,DECODE(GCC.SEGMENT3,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
(GCC.CHART_OF_ACCOUNTS_ID,3,GCC.SEGMENT3)) SEG3_DESC
,DECODE(GCC.SEGMENT4,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,4,GCC.SEGMENT4)) SEG4_DESC
,DECODE(GCC.SEGMENT5,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,5,GCC.SEGMENT5)) SEG5_DESC
,DECODE(GCC.SEGMENT6,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,6,GCC.SEGMENT6)) SEG6_DESC
,DECODE(GCC.SEGMENT7,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,7,GCC.SEGMENT7)) SEG7_DESC
,DECODE(GCC.SEGMENT9,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,8,GCC.SEGMENT8)) SEG8_DESC
,GCC.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
,GCC.ACCOUNT_TYPE
FROM GL_CODE_COMBINATIONS GCC
WHERE GCC.CHART_OF_ACCOUNTS_ID = 53662
,GL_FLEXFIELDS_PKG.GET_ACCOUNT_SEGMENT(GCC.CHART_OF_ACCOUNTS_ID) GET_ACCOUNT_SEGMENT
,GL_FLEXFIELDS_PKG.GET_COA_NAME(GCC.CHART_OF_ACCOUNTS_ID) GET_COA_NAME
,GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION(GCC.CHART_OF_ACCOUNTS_ID,GCC.CODE_COMBINATION_ID) GET_CONCAT_DESCRIPTION
,GCC.SEGMENT1
,GCC.SEGMENT2
,GCC.SEGMENT3
,GCC.SEGMENT4
,GCC.SEGMENT5
,GCC.SEGMENT6
,GCC.SEGMENT7
,GCC.SEGMENT8
,DECODE(GCC.SEGMENT1,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
(GCC.CHART_OF_ACCOUNTS_ID,1,GCC.SEGMENT1)) SEG1_DESC
,DECODE(GCC.SEGMENT2,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,2,GCC.SEGMENT2)) SEG2_DESC
,DECODE(GCC.SEGMENT3,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
(GCC.CHART_OF_ACCOUNTS_ID,3,GCC.SEGMENT3)) SEG3_DESC
,DECODE(GCC.SEGMENT4,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,4,GCC.SEGMENT4)) SEG4_DESC
,DECODE(GCC.SEGMENT5,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,5,GCC.SEGMENT5)) SEG5_DESC
,DECODE(GCC.SEGMENT6,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,6,GCC.SEGMENT6)) SEG6_DESC
,DECODE(GCC.SEGMENT7,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,7,GCC.SEGMENT7)) SEG7_DESC
,DECODE(GCC.SEGMENT9,NULL,'',APPS.GL_FLEXFIELDS_PKG.GET_DESCRIPTION_SQL
( GCC.CHART_OF_ACCOUNTS_ID,8,GCC.SEGMENT8)) SEG8_DESC
,GCC.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
,GCC.ACCOUNT_TYPE
FROM GL_CODE_COMBINATIONS GCC
WHERE GCC.CHART_OF_ACCOUNTS_ID = 53662
No comments:
Post a Comment