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.GL_JE_HEADER_SECURITY dependencies on GL_LEDGER_SEGMENT_VALUES

Line 39: FROM GL_LEDGER_SEGMENT_VALUES sv

35: FROM GL_JE_SEGMENT_VALUES jsv
36: WHERE jsv.segment_type_code = p_segment_type_code
37: AND jsv.je_header_id = p_je_header_id
38: AND NOT EXISTS (SELECT 'Valid'
39: FROM GL_LEDGER_SEGMENT_VALUES sv
40: WHERE NVL(trunc(p_edate), NVL(sv.start_date,TO_DATE('1950/01/01','YYYY/MM/DD')))
41: BETWEEN NVL(sv.start_date,TO_DATE('1950/01/01','YYYY/MM/DD'))
42: AND NVL(sv.end_date,TO_DATE('9999/01/01','YYYY/MM/DD'))
43: AND sv.segment_value = jsv.segment_value

Line 55: FROM GL_LEDGER_SEGMENT_VALUES sv

51: SELECT 'Invalid'
52: FROM GL_JE_SEGMENT_VALUES jsv
53: WHERE jsv.je_header_id = p_je_header_id
54: AND NOT EXISTS (SELECT 'Valid'
55: FROM GL_LEDGER_SEGMENT_VALUES sv
56: WHERE NVL(trunc(p_edate), NVL(sv.start_date,TO_DATE('1950/01/01','YYYY/MM/DD')))
57: BETWEEN NVL(sv.start_date,TO_DATE('1950/01/01','YYYY/MM/DD'))
58: AND NVL(sv.end_date,TO_DATE('9999/01/01','YYYY/MM/DD'))
59: AND sv.segment_value = jsv.segment_value