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_SETS_OF_BOOKS

Line 81: (select sob.currency_code from gl_sets_of_books sob where sob.set_of_books_id = gh.ledger_id),

77: gl.je_line_num,
78: gl.code_combination_id,
79: nvl(gh.ussgl_transaction_code, '*'),
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

Line 101: TYPE ledger_currency_code_type IS TABLE OF gl_sets_of_books.currency_code%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:
103: je_header_id_tab je_header_id_type;
104: je_line_num_tab je_line_num_type;
105: code_combination_id_tab code_combination_id_type;

Line 422: (select sob.currency_code from gl_sets_of_books sob where sob.set_of_books_id = gh.ledger_id),

418: gl.je_line_num,
419: gl.code_combination_id,
420: nvl(gh.ussgl_transaction_code, '*'),
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

Line 442: TYPE ledger_currency_code_type IS TABLE OF gl_sets_of_books.currency_code%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:
444: je_header_id_tab je_header_id_type;
445: je_line_num_tab je_line_num_type;
446: code_combination_id_tab code_combination_id_type;