APPS.GL_JOURNALS_AUTOCOPY dependencies on GL_JE_LINES

Line 402: INSERT INTO gl_je_lines

398: t2 =>'TABLE',
399: v2 =>'GL_JE_HEADERS');
400:
401: -- Insert the new journal lines
402: INSERT INTO gl_je_lines
403: (je_header_id, je_line_num, ledger_id,
404: code_combination_id, period_name, effective_date,
405: status, entered_dr, entered_cr, accounted_dr, accounted_cr,
406: description, stat_amount, ignore_rate_flag,

Line 444: fnd_currencies curr, gl_je_lines jel

440: jel.ussgl_transaction_code,
441: jel.co_third_party,
442: sysdate, usr_id, sysdate, usr_id, log_id
443: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_ledgers lgr,
444: fnd_currencies curr, gl_je_lines jel
445: WHERE jeh1.je_batch_id = jeb_id
446: AND jeh2.je_batch_id = new_jeb_id
447: AND jeh2.name IN (jeh1.name,
448: substrb(jeh1.name,

Line 462: v2 =>'GL_JE_LINES');

458: token_num => 2 ,
459: t1 =>'NUM',
460: v1 =>to_char(temp),
461: t2 =>'TABLE',
462: v2 =>'GL_JE_LINES');
463:
464: -- Insert the new journal segment values
465: INSERT INTO gl_je_segment_values
466: (je_header_id, segment_type_code, segment_value,

Line 490: INSERT INTO gl_je_lines_recon

486: t2 =>'TABLE',
487: v2 =>'GL_JE_SEGMENT_VALUES');
488:
489: -- Insert reconciliation data
490: INSERT INTO gl_je_lines_recon
491: (je_header_id, je_line_num, ledger_id,
492: jgzz_recon_ref,
493: creation_date, created_by, last_update_date,
494: last_updated_by, last_update_login)

Line 500: gl_ledgers lgr, gl_je_lines jel,

496: rec.jgzz_recon_ref,
497: sysdate, usr_id, sysdate,
498: usr_id, log_id
499: FROM gl_je_batches jeb, gl_je_headers jeh1, gl_je_headers jeh2,
500: gl_ledgers lgr, gl_je_lines jel,
501: gl_code_combinations cc, gl_je_lines_recon rec
502: WHERE jeb.je_batch_id = jeb_id
503: AND jeb.average_journal_flag = 'N'
504: AND jeh1.je_batch_id = jeb_id

Line 501: gl_code_combinations cc, gl_je_lines_recon rec

497: sysdate, usr_id, sysdate,
498: usr_id, log_id
499: FROM gl_je_batches jeb, gl_je_headers jeh1, gl_je_headers jeh2,
500: gl_ledgers lgr, gl_je_lines jel,
501: gl_code_combinations cc, gl_je_lines_recon rec
502: WHERE jeb.je_batch_id = jeb_id
503: AND jeb.average_journal_flag = 'N'
504: AND jeh1.je_batch_id = jeb_id
505: AND jeh1.actual_flag = 'A'

Line 527: v2 =>'GL_JE_LINES_RECON');

523: token_num => 2 ,
524: t1 =>'NUM',
525: v1 =>to_char(temp),
526: t2 =>'TABLE',
527: v2 =>'GL_JE_LINES_RECON');
528:
529: -- Fix the running totals for the journals
530: UPDATE gl_je_headers jeh
531: SET (running_total_dr, running_total_cr,

Line 535: FROM gl_je_lines jel

531: SET (running_total_dr, running_total_cr,
532: running_total_accounted_dr, running_total_accounted_cr)
533: = (SELECT sum(nvl(entered_dr,0)), sum(nvl(entered_cr,0)),
534: sum(nvl(accounted_dr,0)), sum(nvl(accounted_cr,0))
535: FROM gl_je_lines jel
536: WHERE jel.je_header_id = jeh.je_header_id)
537: WHERE jeh.je_batch_id = new_jeb_id;
538:
539: -- Fix the batch running totals