GL Chart of Accounts - Suspense Accounts Listing
Description
- Categories
- BI Publisher
- Application
- General Ledger
- Source
- Chart of Accounts - Suspense Accounts Listing (XML)
- Short Name
- GLXRLSUS_XML
- DB package
- GL_GLXRLSUS_XMLP_PKG
SQL 19 lines
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 |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Ledger | LOV Oracle |