eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_UPD_GIR_MTA_WTA dependencies on GL_JE_LINES

Line 84: gl_je_lines gl

80: gh.currency_code,
81: (select sob.currency_code from gl_sets_of_books sob where sob.set_of_books_id = gh.ledger_id),
82: decode(gl.entered_dr, NULL, 0, 1) + decode(gl.entered_cr, NULL, 0, -1)
83: from gl_je_headers gh,
84: gl_je_lines gl
85: where gh.je_batch_id = p_je_batch_id
86: and gl.je_header_id = gh.je_header_id
87: and gh.je_category = 'MTL'
88: and gh.actual_flag = 'A'

Line 96: TYPE je_header_id_type IS TABLE OF gl_je_lines.je_header_id%TYPE;

92: and jir.gl_sl_link_table = 'MTA'
93: and (jir.gl_sl_link_id is null or p_rerun_mode = 'Y') --Flexible Logic
94: and jir.reference_3 is null);
95:
96: TYPE je_header_id_type IS TABLE OF gl_je_lines.je_header_id%TYPE;
97: TYPE je_line_num_type IS TABLE OF gl_je_lines.je_line_num%TYPE;
98: TYPE code_combination_id_type IS TABLE OF gl_je_lines.code_combination_id%TYPE;
99: TYPE ussgl_transaction_code_type IS TABLE OF gl_je_headers.ussgl_transaction_code%TYPE;
100: TYPE gl_currency_code_type IS TABLE OF gl_je_headers.currency_code%TYPE;

Line 97: TYPE je_line_num_type IS TABLE OF gl_je_lines.je_line_num%TYPE;

93: and (jir.gl_sl_link_id is null or p_rerun_mode = 'Y') --Flexible Logic
94: and jir.reference_3 is null);
95:
96: TYPE je_header_id_type IS TABLE OF gl_je_lines.je_header_id%TYPE;
97: TYPE je_line_num_type IS TABLE OF gl_je_lines.je_line_num%TYPE;
98: TYPE code_combination_id_type IS TABLE OF gl_je_lines.code_combination_id%TYPE;
99: TYPE ussgl_transaction_code_type IS TABLE OF gl_je_headers.ussgl_transaction_code%TYPE;
100: TYPE gl_currency_code_type IS TABLE OF gl_je_headers.currency_code%TYPE;
101: TYPE ledger_currency_code_type IS TABLE OF gl_sets_of_books.currency_code%TYPE;

Line 98: TYPE code_combination_id_type IS TABLE OF gl_je_lines.code_combination_id%TYPE;

94: and jir.reference_3 is null);
95:
96: TYPE je_header_id_type IS TABLE OF gl_je_lines.je_header_id%TYPE;
97: TYPE je_line_num_type IS TABLE OF gl_je_lines.je_line_num%TYPE;
98: TYPE code_combination_id_type IS TABLE OF gl_je_lines.code_combination_id%TYPE;
99: TYPE ussgl_transaction_code_type IS TABLE OF gl_je_headers.ussgl_transaction_code%TYPE;
100: TYPE gl_currency_code_type IS TABLE OF gl_je_headers.currency_code%TYPE;
101: TYPE ledger_currency_code_type IS TABLE OF gl_sets_of_books.currency_code%TYPE;
102:

Line 425: gl_je_lines gl

421: gh.currency_code,
422: (select sob.currency_code from gl_sets_of_books sob where sob.set_of_books_id = gh.ledger_id),
423: decode(gl.entered_dr, NULL, 0, 1) + decode(gl.entered_cr, NULL, 0, -1)
424: from gl_je_headers gh,
425: gl_je_lines gl
426: where gh.je_batch_id = p_je_batch_id
427: and gl.je_header_id = gh.je_header_id
428: and gh.je_category = 'WIP'
429: and gh.actual_flag = 'A'

Line 437: TYPE je_header_id_type IS TABLE OF gl_je_lines.je_header_id%TYPE;

433: and jir.gl_sl_link_table = 'WTA'
434: and (jir.gl_sl_link_id is null or p_rerun_mode = 'Y') --Flexible Logic
435: and jir.reference_3 is null);
436:
437: TYPE je_header_id_type IS TABLE OF gl_je_lines.je_header_id%TYPE;
438: TYPE je_line_num_type IS TABLE OF gl_je_lines.je_line_num%TYPE;
439: TYPE code_combination_id_type IS TABLE OF gl_je_lines.code_combination_id%TYPE;
440: TYPE ussgl_transaction_code_type IS TABLE OF gl_je_headers.ussgl_transaction_code%TYPE;
441: TYPE gl_currency_code_type IS TABLE OF gl_je_headers.currency_code%TYPE;

Line 438: TYPE je_line_num_type IS TABLE OF gl_je_lines.je_line_num%TYPE;

434: and (jir.gl_sl_link_id is null or p_rerun_mode = 'Y') --Flexible Logic
435: and jir.reference_3 is null);
436:
437: TYPE je_header_id_type IS TABLE OF gl_je_lines.je_header_id%TYPE;
438: TYPE je_line_num_type IS TABLE OF gl_je_lines.je_line_num%TYPE;
439: TYPE code_combination_id_type IS TABLE OF gl_je_lines.code_combination_id%TYPE;
440: TYPE ussgl_transaction_code_type IS TABLE OF gl_je_headers.ussgl_transaction_code%TYPE;
441: TYPE gl_currency_code_type IS TABLE OF gl_je_headers.currency_code%TYPE;
442: TYPE ledger_currency_code_type IS TABLE OF gl_sets_of_books.currency_code%TYPE;

Line 439: TYPE code_combination_id_type IS TABLE OF gl_je_lines.code_combination_id%TYPE;

435: and jir.reference_3 is null);
436:
437: TYPE je_header_id_type IS TABLE OF gl_je_lines.je_header_id%TYPE;
438: TYPE je_line_num_type IS TABLE OF gl_je_lines.je_line_num%TYPE;
439: TYPE code_combination_id_type IS TABLE OF gl_je_lines.code_combination_id%TYPE;
440: TYPE ussgl_transaction_code_type IS TABLE OF gl_je_headers.ussgl_transaction_code%TYPE;
441: TYPE gl_currency_code_type IS TABLE OF gl_je_headers.currency_code%TYPE;
442: TYPE ledger_currency_code_type IS TABLE OF gl_sets_of_books.currency_code%TYPE;
443: