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 446: fnd_currencies curr, gl_je_lines jel

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

Line 464: v2 =>'GL_JE_LINES');

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

Line 492: INSERT INTO gl_je_lines_recon

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

Line 502: gl_ledgers lgr, gl_je_lines jel,

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

Line 503: gl_code_combinations cc, gl_je_lines_recon rec

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

Line 529: v2 =>'GL_JE_LINES_RECON');

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

Line 537: FROM gl_je_lines jel

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