GL_CODE_COMBINATIONS Query - Oracle EBS R12

https://generalledger-gl.blogspot.com/2017/09/glcodecombinations-query.htm

PLSQL Query to Get GL_CODE_COMBINATIONS

select

 gcc.SEGMENT1 || '-' || gcc.SEGMENT2 || '-' || gcc.SEGMENT3 || '-' ||
 gcc.SEGMENT4 || '-' || gcc.SEGMENT5 || '-' || gcc.SEGMENT6 || '-' ||
 gcc.SEGMENT7 || '-' || gcc.SEGMENT8 Code_Combination,

 decode(gcc.detail_posting_allowed_flag, 'Y', '*', '') POSTING_ALLOWED,

 decode(gcc.detail_budgeting_allowed_flag,
       
        'Y',
        '*',
        '') BUDGET_ALLOWED,

 decode(gcc.summary_flag,
       
        'Y',
        ' ',
       
        gl1.description) ACCOUNT_TYPE,

 gcc.summary_flag SUMMARY_FLAG,

 decode(gcc.summary_flag, 'Y', '*', '') SUMMARY,

 gcc.enabled_flag ENABLED_FLAG,

 decode(gcc.enabled_flag, 'Y', '*', '') ENABLED,

 gcc.start_date_active START_DATE,

 gcc.end_date_active END_DATE

  from gl_lookups gl1,
     
       gl_code_combinations gcc

 where

--gcc.chart_of_accounts_id = &P_STRUCT_NUM

 gcc.account_type = gl1.lookup_code

 and gl1.lookup_type = 'ACCOUNT TYPE'

 order by gcc.SEGMENT4