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.OTA_TIMEZONE_UTIL dependencies on OTA_CATEGORY_USAGES

Line 8: ,ota_category_usages ctu

4: CURSOR get_class_info(p_class_id NUMBER) IS
5: SELECT ctu.online_flag, evt.timezone
6: FROM ota_events evt
7: ,ota_offerings ofn
8: ,ota_category_usages ctu
9: WHERE evt.parent_offering_id = ofn.offering_id
10: AND ctu.category_usage_id = ofn.delivery_mode_id
11: AND ctu.type = 'DM'
12: AND evt.event_id = p_class_id;

Line 20: , ota_category_usages ctu

16: ,trb.timezone_code
17: ,ftl.name timezone
18: FROM ota_resource_bookings trb
19: , ota_events evt
20: , ota_category_usages ctu
21: , ota_offerings ofn
22: , fnd_timezones_tl ftl
23: WHERE evt.parent_offering_id = ofn.offering_id
24: AND evt.event_id = trb.event_id