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_LRNG_PATH_MEMBER_UTIL dependencies on OTA_OFFERINGS

Line 1357: ota_offerings ofr,

1353: CURSOR class_type IS
1354: SELECT ocu.synchronous_flag,
1355: ocu.online_flag
1356: FROM ota_events oev,
1357: ota_offerings ofr,
1358: ota_category_usages ocu
1359: WHERE oev.parent_offering_id = ofr.offering_id
1360: AND ocu.category_usage_Id = ofr.delivery_mode_id
1361: AND oev.event_id = p_event_id;

Line 1368: ota_offerings ofr,

1364: p_user_id IN ota_attempts.user_id%type,
1365: p_user_type IN ota_attempts.user_type%type) IS
1366: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1367: FROM ota_events oev,
1368: ota_offerings ofr,
1369: ota_performances opf,
1370: ota_category_usages ocu,
1371: ota_delegate_bookings odb,
1372: ota_booking_status_types obst

Line 1390: ota_offerings ofr,

1386: p_user_id IN ota_attempts.user_id%type,
1387: p_user_type IN ota_attempts.user_type%type) IS
1388: SELECT ota_timezone_util.get_dateDT(trunc(opf.completed_date), to_char(opf.completed_date, 'HH24:MI:SS'), ocu.Online_Flag, ota_timezone_util.get_server_timezone_code) completion_date
1389: FROM ota_events oev,
1390: ota_offerings ofr,
1391: ota_performances opf,
1392: ota_category_usages ocu,
1393: ota_delegate_bookings odb,
1394: ota_booking_status_types obst