DBA Data[Home] [Help]

APPS.GL_JOURNALS_AUTOCOPY dependencies on GL_JE_LINES_RECON

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