eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_RECON_REP dependencies on GL_INTERFACE

Line 4737: set (gl_interface_dr, gl_interface_cr) =

4733: and gjh.currency_code <> 'STAT'
4734: group by gjl.code_combination_id);
4735:
4736: update ar_gl_recon_gt argt
4737: set (gl_interface_dr, gl_interface_cr) =
4738: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,
4739: sum(nvl(gif.accounted_cr,0)) gl_interface_cr
4740: from gl_interface gif,
4741: gl_je_sources gjs

Line 4738: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,

4734: group by gjl.code_combination_id);
4735:
4736: update ar_gl_recon_gt argt
4737: set (gl_interface_dr, gl_interface_cr) =
4738: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,
4739: sum(nvl(gif.accounted_cr,0)) gl_interface_cr
4740: from gl_interface gif,
4741: gl_je_sources gjs
4742: where gif.code_combination_id = argt.code_combination_id

Line 4739: sum(nvl(gif.accounted_cr,0)) gl_interface_cr

4735:
4736: update ar_gl_recon_gt argt
4737: set (gl_interface_dr, gl_interface_cr) =
4738: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,
4739: sum(nvl(gif.accounted_cr,0)) gl_interface_cr
4740: from gl_interface gif,
4741: gl_je_sources gjs
4742: where gif.code_combination_id = argt.code_combination_id
4743: and gif.accounting_date between get_gl_date_from() and get_gl_date_to()

Line 4740: from gl_interface gif,

4736: update ar_gl_recon_gt argt
4737: set (gl_interface_dr, gl_interface_cr) =
4738: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,
4739: sum(nvl(gif.accounted_cr,0)) gl_interface_cr
4740: from gl_interface gif,
4741: gl_je_sources gjs
4742: where gif.code_combination_id = argt.code_combination_id
4743: and gif.accounting_date between get_gl_date_from() and get_gl_date_to()
4744: and gif.user_je_source_name = gjs.user_je_source_name

Line 4782: nvl(gl_interface_dr,0) gl_interface_debit,

4778: nvl(subledger_rec_dr,0) subledger_receivables_debit,
4779: nvl(subledger_rec_cr,0) subledger_receivables_credit,
4780: nvl(gl_unposted_dr,0) gl_unposted_debit,
4781: nvl(gl_unposted_cr,0) gl_unposted_credit,
4782: nvl(gl_interface_dr,0) gl_interface_debit,
4783: nvl(gl_interface_cr,0) gl_interface_credit,
4784: nvl(receivables_dr,0) receivables_debit,
4785: nvl(receivables_cr,0) receivables_credit
4786: from ar_gl_recon_gt

Line 4783: nvl(gl_interface_cr,0) gl_interface_credit,

4779: nvl(subledger_rec_cr,0) subledger_receivables_credit,
4780: nvl(gl_unposted_dr,0) gl_unposted_debit,
4781: nvl(gl_unposted_cr,0) gl_unposted_credit,
4782: nvl(gl_interface_dr,0) gl_interface_debit,
4783: nvl(gl_interface_cr,0) gl_interface_credit,
4784: nvl(receivables_dr,0) receivables_debit,
4785: nvl(receivables_cr,0) receivables_credit
4786: from ar_gl_recon_gt
4787: where ''N'' = arp_recon_rep.get_out_of_balance_only()