DBA Data[Home] [Help]

APPS.GL_JOURNALS_AUTOCOPY dependencies on GL_JE_LINES_RECON

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 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,