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.OZF_FUND_UTILIZED_PUB dependencies on JTF_LOC_HIERARCHIES_VL

Line 66: jtf_loc_hierarchies_vl loc,

62:
63: CURSOR c_valid_event (p_activity_id IN NUMBER, p_approver_id IN NUMBER) IS
64: SELECT event.event_header_id
65: FROM ams_event_headers_vl event,
66: jtf_loc_hierarchies_vl loc,
67: ams_act_access_denorm acc
68: WHERE loc.location_type_code = 'COUNTRY'
69: AND event.active_flag='Y'
70: AND event.event_level='MAIN'

Line 83: jtf_loc_hierarchies_vl c

79: CURSOR c_valid_deliverable (p_activity_id IN NUMBER) IS
80: SELECT b.deliverable_id
81: FROM ams_deliverables_all_b b,
82: ams_deliverables_all_tl tl,
83: jtf_loc_hierarchies_vl c
84: WHERE c.location_type_code = 'COUNTRY'
85: AND b.active_flag='Y'
86: AND c.location_hierarchy_id = b.country_id
87: AND b.deliverable_id = tl.deliverable_id