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 2967: set (gl_interface_dr, gl_interface_cr) =

2963: and gjh.currency_code <> 'STAT'
2964: group by gjl.code_combination_id);
2965:
2966: update ar_gl_recon_gt argt
2967: set (gl_interface_dr, gl_interface_cr) =
2968: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,
2969: sum(nvl(gif.accounted_cr,0)) gl_interface_cr
2970: from gl_interface gif,
2971: gl_je_sources gjs

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

2964: group by gjl.code_combination_id);
2965:
2966: update ar_gl_recon_gt argt
2967: set (gl_interface_dr, gl_interface_cr) =
2968: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,
2969: sum(nvl(gif.accounted_cr,0)) gl_interface_cr
2970: from gl_interface gif,
2971: gl_je_sources gjs
2972: where gif.code_combination_id = argt.code_combination_id

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

2965:
2966: update ar_gl_recon_gt argt
2967: set (gl_interface_dr, gl_interface_cr) =
2968: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,
2969: sum(nvl(gif.accounted_cr,0)) gl_interface_cr
2970: from gl_interface gif,
2971: gl_je_sources gjs
2972: where gif.code_combination_id = argt.code_combination_id
2973: and gif.accounting_date between get_gl_date_from() and get_gl_date_to()

Line 2970: from gl_interface gif,

2966: update ar_gl_recon_gt argt
2967: set (gl_interface_dr, gl_interface_cr) =
2968: (select sum(nvl(gif.accounted_dr,0)) gl_interface_dr,
2969: sum(nvl(gif.accounted_cr,0)) gl_interface_cr
2970: from gl_interface gif,
2971: gl_je_sources gjs
2972: where gif.code_combination_id = argt.code_combination_id
2973: and gif.accounting_date between get_gl_date_from() and get_gl_date_to()
2974: and gif.user_je_source_name = gjs.user_je_source_name

Line 3006: nvl(gl_interface_dr,0) gl_interface_debit,

3002: nvl(subledger_rec_dr,0) subledger_receivables_debit,
3003: nvl(subledger_rec_cr,0) subledger_receivables_credit,
3004: nvl(gl_unposted_dr,0) gl_unposted_debit,
3005: nvl(gl_unposted_cr,0) gl_unposted_credit,
3006: nvl(gl_interface_dr,0) gl_interface_debit,
3007: nvl(gl_interface_cr,0) gl_interface_credit,
3008: nvl(receivables_dr,0) receivables_debit,
3009: nvl(receivables_cr,0) receivables_credit
3010: from ar_gl_recon_gt

Line 3007: nvl(gl_interface_cr,0) gl_interface_credit,

3003: nvl(subledger_rec_cr,0) subledger_receivables_credit,
3004: nvl(gl_unposted_dr,0) gl_unposted_debit,
3005: nvl(gl_unposted_cr,0) gl_unposted_credit,
3006: nvl(gl_interface_dr,0) gl_interface_debit,
3007: nvl(gl_interface_cr,0) gl_interface_credit,
3008: nvl(receivables_dr,0) receivables_debit,
3009: nvl(receivables_cr,0) receivables_credit
3010: from ar_gl_recon_gt
3011: where ''N'' = arp_recon_rep.get_out_of_balance_only()