Code Combinations CCID
------------------------------------
The GL Code Combinations extract can be select by chart of accounts, specific segment values or specific code combination attributes.
This can be used for chart of accounts maintenance and review
I have tested in 11.5.10.2 Instance. This will work in all the 11i Instances.
I have commented the SOB condition. Check your Instances SOB short-name and provide accordingly if you have multiple SOB in your business Structure.
SELECT FST.ID_FLEX_STRUCTURE_NAME, GCC.SEGMENT1||'-'||GCC.SEGMENT2||'-'||GCC.SEGMENT3||'-'||GCC.SEGMENT4||'-'||GCC.SEGMENT5||'-'||GCC.SEGMENT6
, GCC.CODE_COMBINATION_ID
, GCC.LAST_UPDATE_DATE
, GCC.JGZZ_RECON_FLAG
, GCC.START_DATE_ACTIVE
, GCC.END_DATE_ACTIVE
, GCC.DETAIL_POSTING_ALLOWED_FLAG
, GCC.ENABLED_FLAG
, GCC.SUMMARY_FLAG
, GCC.START_DATE_ACTIVE
FROM GL_CODE_COMBINATIONS GCC
, FND_ID_FLEX_STRUCTURES_VL FST
WHERE FST.ID_FLEX_NUM = GCC.CHART_OF_ACCOUNTS_ID
AND FST.APPLICATION_ID = 101
AND FST.ID_FLEX_CODE = 'GL#'
--AND GCC.SEGMENT1 IN ('25','26','30')
--AND SUBSTR(FST.ID_FLEX_STRUCTURE_NAME,1,2) IN ('HB')
ORDER BY 1,2,3