DBA Data[Home] [Help]

APPS.GL_JOURNALS_AUTOCOPY dependencies on GL_JE_SEGMENT_VALUES

Line 465: INSERT INTO gl_je_segment_values

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,
467: creation_date, created_by,
468: last_update_date, last_updated_by, last_update_login)
469: SELECT

Line 472: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_je_segment_values sv

468: last_update_date, last_updated_by, last_update_login)
469: SELECT
470: jeh2.je_header_id, sv.segment_type_code, sv.segment_value,
471: sysdate, usr_id, sysdate, usr_id, log_id
472: FROM gl_je_headers jeh1, gl_je_headers jeh2, gl_je_segment_values sv
473: WHERE jeh1.je_batch_id = jeb_id
474: AND jeh2.je_batch_id = new_jeb_id
475: AND jeh2.name IN (jeh1.name,
476: substrb(jeh1.name,

Line 487: v2 =>'GL_JE_SEGMENT_VALUES');

483: token_num => 2 ,
484: t1 =>'NUM',
485: v1 =>to_char(temp),
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,