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_TRNG_PLAN_UTIL_SS dependencies on OTA_BOOKING_STATUS_TYPES

Line 106: ota_booking_status_types bst,

102: SELECT DECODE(bst.type,'C','Z',bst.type) status
103: FROM ota_training_plan_members tpm,
104: ota_events evt,
105: ota_delegate_bookings tdb,
106: ota_booking_status_types bst,
107: ota_training_plans tps
108: WHERE tpm.activity_version_id=evt.activity_version_id
109: AND evt.event_id = tdb.event_id
110: AND bst.booking_status_type_id = tdb.booking_status_type_id

Line 304: ota_booking_status_types s,

300: SELECT NULL
301: FROM ota_events e,
302: ota_activity_versions a,
303: ota_delegate_bookings b,
304: ota_booking_status_types s,
305: ota_training_plan_members tpm
306: WHERE e.event_id = b.event_id
307: AND tpm.activity_version_id = a.activity_version_id
308: AND ((e.course_start_date >= tpm.earliest_start_date

Line 368: ota_booking_status_types bst

364: CURSOR enroll_status_dates IS
365: SELECT DECODE(bst.type,'C','Z',bst.type) status
366: FROM ota_events evt,
367: ota_delegate_bookings tdb,
368: ota_booking_status_types bst
369: WHERE evt.event_id = tdb.event_id
370: AND bst.booking_status_type_id = tdb.booking_status_type_id
371: AND (
372: evt.course_start_date >= p_earliest_start_date

Line 395: ota_booking_status_types bst

391: CURSOR enroll_status_without_dates IS
392: SELECT DECODE(bst.type,'C','Z',bst.type) status
393: FROM ota_events evt,
394: ota_delegate_bookings tdb,
395: ota_booking_status_types bst
396: WHERE evt.event_id = tdb.event_id
397: AND bst.booking_status_type_id = tdb.booking_status_type_id
398: AND evt.activity_version_id = p_activity_version_id
399: -- Modified for Bug#3479186