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.GL_JE_LINES_RECON_PKG dependencies on GL_JE_HEADERS

Line 15: FROM gl_je_batches jeb, gl_je_headers jeh, gl_ledgers lgr, gl_je_lines jel,

11: last_updated_by, last_update_login, jgzz_recon_ref)
12: SELECT jeh.je_header_id, jel.je_line_num, jeh.ledger_id,
13: sysdate, X_Last_Updated_By, sysdate,
14: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
15: FROM gl_je_batches jeb, gl_je_headers jeh, gl_ledgers lgr, gl_je_lines jel,
16: gl_code_combinations cc
17: WHERE jeb.je_batch_id = X_Je_Batch_Id
18: AND jeb.average_journal_flag = 'N'
19: AND jeh.je_batch_id = X_Je_Batch_Id

Line 42: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,

38: last_updated_by, last_update_login, jgzz_recon_ref)
39: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
40: sysdate, X_Last_Updated_By, sysdate,
41: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
42: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
43: gl_code_combinations cc
44: WHERE jeh.je_header_id = X_Je_Header_Id
45: AND jeh.actual_flag = 'A'
46: AND jeh.je_source NOT IN ('Move/Merge', 'Move/Merge Reversal')

Line 70: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,

66: last_updated_by, last_update_login, jgzz_recon_ref)
67: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
68: sysdate, X_Last_Updated_By, sysdate,
69: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
70: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
71: gl_code_combinations cc
72: WHERE jeh.je_header_id = X_Je_Header_Id
73: AND jeh.actual_flag = 'A'
74: AND jeh.je_source NOT IN ('Move/Merge', 'Move/Merge Reversal')

Line 260: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,

256: last_updated_by, last_update_login, jgzz_recon_ref)
257: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
258: sysdate, X_Last_Updated_By, sysdate,
259: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
260: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
261: gl_code_combinations cc
262: WHERE jeh.je_header_id = X_Je_Header_Id
263: AND jeh.actual_flag = 'A'
264: AND jeh.je_source NOT IN ('Move/Merge', 'Move/Merge Reversal')

Line 304: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,

300: last_updated_by, last_update_login, jgzz_recon_ref)
301: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
302: sysdate, X_Last_Updated_By, sysdate,
303: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
304: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
305: gl_code_combinations cc
306: WHERE jeb.posting_run_id = X_Prun_Id
307: AND jeb.status = 'I'
308: AND jeb.average_journal_flag = 'N'

Line 349: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr,

345: last_updated_by, last_update_login, jgzz_recon_ref)
346: SELECT sljel.je_header_id, sljel.je_line_num, sljel.ledger_id,
347: sysdate, X_Last_Updated_By, sysdate,
348: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
349: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr,
350: gl_je_batches sljeb, gl_je_headers sljeh, gl_je_lines sljel,
351: gl_code_combinations cc
352: WHERE jeb.posting_run_id = X_Prun_Id
353: AND jeb.status = 'I'

Line 350: gl_je_batches sljeb, gl_je_headers sljeh, gl_je_lines sljel,

346: SELECT sljel.je_header_id, sljel.je_line_num, sljel.ledger_id,
347: sysdate, X_Last_Updated_By, sysdate,
348: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
349: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr,
350: gl_je_batches sljeb, gl_je_headers sljeh, gl_je_lines sljel,
351: gl_code_combinations cc
352: WHERE jeb.posting_run_id = X_Prun_Id
353: AND jeb.status = 'I'
354: AND jeh.je_batch_id = jeb.je_batch_id