GL Chart of Accounts - Detail Listing

select
  null  FLEX_DATA_ALL, 
  null  FLEX_DATA_BAL, 
  null  FLEX_DATA_SEG,
  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, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_bal_unpad', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') FLEX_FIELD_BAL_UNPAD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_bal_pad', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'PADDED_VALUE') FLEX_FIELD_BAL_PAD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_desc_bal', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'FULL_DESCRIPTION') FLEX_DESC_BAL, 
	--null FLEX_APROMPT_BAL, 
	--null FLEX_LPROMPT_BAL, 
	&FLEX_FIELD_SEG_UNPAD FLEX_FIELD_SEG_UNPAD, 
	&FLEX_FIELD_SEG_PAD FLEX_FIELD_SEG_PAD, 
	&FLEX_DESC_SEG FLEX_DESC_SEG, 
	--null FLEX_APROMPT_SEG, 
	--null FLEX_LPROMPT_SEG, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_all', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_FIELD_ALL
from
  gl_lookups  gl1,
  gl_code_combinations  gcc
where
  gcc.chart_of_accounts_id = :P_STRUCT_NUM 
  and &FLEX_WHERE_ALL 
  and gcc.account_type = gl1.lookup_code 
  and gl1.lookup_type = 'ACCOUNT TYPE'
order by
  gcc.summary_flag,
  gcc.enabled_flag  desc,
  &FLEX_ORDERBY_BAL,
  &FLEX_ORDERBY_SEG,
  &FLEX_ORDERBY_ALL