EBS总账模块与其他模块数据关联关系 - 王小航 - 博客园2022-08-24
1、gjh.je_source = 'Payables':. 1)与 AP 模块关联表:ap_ae_lines_all. 2)SQL 语句:. select * from gl_je_headers gjh, gl_je_lines gjl, gl_import_references gir, ap_ae_lines_all ael, ap_ae_headers_all aeh where gjh.je_header_id = gjl.je_header_id and gjl.je_header_id = gir.je_header_id and gjl.je_line_num = gir.je_line_num and gjh ...
了解详情