GL Consolidation - Journals
Description
Categories: BI Publisher
Application: General Ledger
Source: Consolidation - Journals (XML)
Short Name: GLCRDR_XML
DB package: GL_GLCRDR_XMLP_PKG
Source: Consolidation - Journals (XML)
Short Name: GLCRDR_XML
DB package: GL_GLCRDR_XMLP_PKG
select null TO_FLEXDATA, null FROM_FLEXDATA, from_jeb.name FROM_BATCH_NAME, from_jeh.name FROM_HEADER_NAME, nvl(from_jel.accounted_dr, 0) DEBITS, nvl(from_jel.accounted_cr, 0) CREDITS, fnd_flex_xml_publisher_apis.process_kff_combination_1('to_flexfield', 'SQLGL', 'GL#', TO_CC.CHART_OF_ACCOUNTS_ID, NULL, TO_CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') TO_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('to_flexfield_pad', 'SQLGL', 'GL#', TO_CC.CHART_OF_ACCOUNTS_ID, NULL, TO_CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') TO_FLEXFIELD_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('to_acctdesc', 'SQLGL', 'GL#', TO_CC.CHART_OF_ACCOUNTS_ID, NULL, TO_CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'FULL_DESCRIPTION') TO_ACCTDESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('from_flexfield', 'SQLGL', 'GL#', FROM_CC.CHART_OF_ACCOUNTS_ID, NULL, FROM_CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FROM_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('from_acctdesc', 'SQLGL', 'GL#', FROM_CC.CHART_OF_ACCOUNTS_ID, NULL, FROM_CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'FULL_DESCRIPTION') FROM_ACCTDESC --commented /*FROM_FLEX FROM_FLEXDATA, from_jeb.name FROM_BATCH_NAME, from_jeh.name FROM_HEADER_NAME, nvl(from_jel.accounted_dr, 0) DEBITS, nvl(from_jel.accounted_cr, 0) CREDITS*/ from gl_code_combinations to_cc, gl_code_combinations from_cc, gl_je_batches from_jeb, gl_je_lines from_jel, gl_je_headers from_jeh, gl_je_lines to_jel, gl_import_references jir where jir.je_header_id in (select to_jeh.je_header_id from gl_je_headers to_jeh where to_jeh.je_batch_id = :P_TO_BATCH_ID) and to_jel.je_header_id = jir.je_header_id and to_jel.je_line_num = jir.je_line_num and from_jeh.je_header_id = jir.reference_3 and from_jel.je_header_id = from_jeh.je_header_id and from_jel.je_line_num = jir.reference_4 and from_jeb.je_batch_id = from_jeh.je_batch_id and from_cc.code_combination_id = from_jel.code_combination_id and to_cc.code_combination_id = to_jel.code_combination_id &WHERE_DAS_CLAUSE order by to_jel.je_header_id, &ORDERBY_TO_FLEX, &ORDERBY_FROM_FLEX |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Consolidation Batch |
|
LOV Oracle | |
Data Access Set Id |
|
Number |