采购、接收、应付业务和会计分录(13)

Oracle 应付模块

子模块追溯

R12

R12下总账追溯子模块比11i简单统一了很多，通过gl_import_reference表，如下蓝色部分sql为关键点：

SELECT h.je_source ,h.je_category

,fnd_flex_ext.get_segs('SQLGL', 'GL#', 50328, ael.code_combination_id) acct ,xla_oa_functions_pkg.get_ccid_description(50328

,ael.code_combination_id) acct_descr ,ael.entered_dr ,ael.entered_cr

FROM gl_je_headers h ,gl_je_lines l

,gl_code_combinations gcc ,gl_period_statuses gps ,gl_import_references ir ,xla_ae_lines ael

WHERE h.je_header_id = l.je_header_id

AND l.code_combination_id = gcc.code_combination_id AND l.period_name = gps.period_name AND gps.application_id = 101 AND gps.set_of_books_id = 2022 AND h.actual_flag = 'A'

AND h.period_name = '2009-01'

AND ir.je_header_id = l.je_header_id AND ir.je_line_num = l.je_line_num AND ael.gl_sl_link_id = ir.gl_sl_link_id

AND ael.gl_sl_link_table = ir.gl_sl_link_table; 11i

附上以前写的一个11i的总账追溯子模块的三栏明细账的sql：11i_gl_journal_drill.sql，11i下测试通过，可以参考。

11i_gl_journal_dr

ill.sql