GL Chart of Accounts - Suspense Accounts Listing

Description

Application: General Ledger
Source: Chart of Accounts - Suspense Accounts Listing (XML)
Short Name: GLXRLSUS_XML
DB package: GL_GLXRLSUS_XMLP_PKG

GL Chart of Accounts - Suspense Accounts Listing and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

select
  gjs.user_je_source_name  JOURNAL_ENTRY_SOURCE,
  gjc.user_je_category_name  JOURNAL_ENTRY_CATEGORY,
  null  FLEX_DATA_ALL, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_FIELD_ALL
from
  gl_code_combinations  gcc,
  gl_je_categories  gjc,
  gl_je_sources  gjs,
  gl_suspense_accounts  gsa
where
          gsa.ledger_id = :P_LEDGER_ID
  and  gsa.je_source_name = gjs.je_source_name
  and  gsa.je_category_name = gjc.je_category_name
  and  gsa.code_combination_id = gcc.code_combination_id (+)
order by
  gjs.user_je_source_name,
  gjc.user_je_category_name