GL Chart of Accounts - Detail Listing

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Chart of Accounts Listing Report
Application: General Ledger
Source: Chart of Accounts - Detail Listing (XML)
Short Name: GLXRLCOA_XML
DB package: GL_GLXRLCOA_XMLP_PKG
Run GL Chart of Accounts - Detail Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Account From 
 
 Char
Account To 
 
 Char
Order By 
 
 LOV Oracle
Download
Related Blitz Reports
OPM2 CAC WIP Pending Cost Adjustment AR Open Balances Revaluation CAC ICP PII Inventory Pending Cost Adjustment FA Asset Additions - draft CE Cleared Transactions CE General Ledger Reconciliation FA Cost Clearing Reconciliation - draft FA Additions By Source FA Asset Impairments
Blitz Report™

Blitz Report™ provides multiple benefits: