3/14/2016 · SELECT distinct gjb.name gl_batch_name, gjl.accounted _cr, gjl.accounted_dr , gjh.name journal_name , gjl.period_name , gjh.je_category , gjh.je_source , gjh.currency …
gjl.accounted_dr , gjl.accounted _cr, gjl.description FROM apps.gl_je_batches gjb, apps.gl_je_headers gjh, apps.gl_je_lines gjl, apps.gl_code_combinations gcc, gl_period_statuses ps WHERE gjb.JE_BATCH_ID = gjh.JE_BATCH_ID AND gjh.je_header_id = gjl.je_header_id AND gjh.actual_flag = ‘A’ AND gjh.status = ‘P’, 7/25/2020 · NVL ( gjl.accounted_dr , 0) dr , NVL ( gjl.accounted _cr, 0) cr, period_offset FROM apps.gl_je_batches gjb, apps.gl_je_headers gjh, apps.gl_je_lines gjl, apps.gl_import_references gir, apps.xla_ae_lines xal, —apps.xla_distribution_links xdl, apps.gl_code_combinations_kfv gcc, apps.ap_suppliers pv, apps.ap_invoices_all aia, —apps.ap_invoice_lines …
4/20/2017 · NVL ( gjl.accounted_dr , 0) AS gl_acc_ dr , NVL ( gjl.accounted _cr, 0) AS gl_acc_cr, NVL (xal.accounted_ dr , 0) AS xla_acc_ dr , NVL (xal.accounted_cr, 0) AS xla_acc_cr FROM xla.xla_transaction_entities xte, ap_invoices_all ai, xla_events xe, xla_ae_lines xal, xla_ae_headers xah, gl_import_references gir, gl_je_headers gjh, gl_je_lines gjl, gl_code …
6/3/2015 · SUM(NVL( GJL.ACCOUNTED_DR ,0))ACCOUNTED_ DR , SUM(NVL( GJL.ACCOUNTED _CR,0))ACCOUNTED_CR, SUM(NVL( GJL.ACCOUNTED_DR ,0)-NVL( GJL.ACCOUNTED _CR,0))BALANCE from gl_je_headers gjh, gl_je_lines gjl, gl_ledgers gl, gl_code_combinations_kfv gcc, GL_JE_BATCHES GJB where gjl.je_header_id = gjh.je_header_id.
9/4/2020 · select xep.name legal_entity, gjh.name jv_name, xl.meaning, gjl.je_line_num, gjl.accounted_dr ,…
11/12/2017 · select xep.name legal_entity, gjh.name jv_name, xl.meaning, gjl.je_line_num, gjl.accounted_dr , gjl.accounted _cr, gl.segment4 natural_account, hou.name operating_unt,, 8/5/2009 · –, gjl.ACCOUNTED_DR –, gjl.ACCOUNTED _CR FROM gl_code_combinations gcc, gl_je_headers gjh, gl_je_lines gjl WHERE gcc. segment4 = ‘42040002’ AND gjl. code_combination_id = gcc. code_combination_id AND gjl. je_header_id = gjh. je_header_id AND TRUNC (gjl. effective_date) <=:p_date AND gjh., gjl.accounted _cr , gjl.accounted_dr ,gjh.name journal_name ,gjh.creation_date journal_creation_date ,gcc.segment1 --,xdl.accounting_line_code from ap_payment_hist_dists aphd ,ap_payment_history_all aph ,ap_checks_all aca ,xla_distribution_links xdl ,xla_ae_lines xal ,xla_ae_headers xah ...
