GL Consolidation - Journals

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

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