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.JL_ZZ_FA_DRILL_DOWN_PKG dependencies on XLA_SUBLEDGERS

Line 39: XLA_SUBLEDGERS for application_id = 140.

35: "GL journal entry source" is set at the application level in SLA.
36: Though, gl_je_source value is available in fa_book_controls
37: for books upgraded from R11i, the source of truth is always as follows.
38: The "GL journal entry source" will be derived from JE_SOURCE_NAME from
39: XLA_SUBLEDGERS for application_id = 140.
40: Hence, there is no need to look at fa_book_controls for books upgraded
41: from R1i.
42: */
43:

Line 52: xla_subledgers xs

48: FROM DUAL
49: WHERE EXISTS ( SELECT 1
50: FROM fa_book_controls bc,
51: gl_je_headers jeh,
52: xla_subledgers xs
53: WHERE jeh.je_header_id = c_jeh_id
54: AND bc.set_of_books_id = jeh.ledger_id
55: AND xs.je_source_name = c_je_source
56: AND xs.application_id = 140