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

Line 779: ota_offerings ofr,

775: ota_cert_enrollments cre,
776: ota_cert_prd_enrollments cpe,
777: ota_cert_mbr_enrollments cme,
778: ota_certification_members cmb,
779: ota_offerings ofr,
780: ota_category_usages c
781: WHERE e.event_id = b.event_id
782: AND cre.cert_enrollment_id = cpe.cert_enrollment_id
783: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id

Line 876: OTA_OFFERINGS O,

872: OTA_EVENTS_TL ET,
873: OTA_DELEGATE_BOOKINGS D,
874: OTA_BOOKING_STATUS_TYPES S,
875: OTA_BOOKING_STATUS_TYPES_TL ST,
876: OTA_OFFERINGS O,
877: OTA_OFFERINGS_TL OT,
878: OTA_CATEGORY_USAGES C,
879: OTA_CATEGORY_USAGES_TL CT,
880: OTA_ACTIVITY_VERSIONS_TL OAV,

Line 877: OTA_OFFERINGS_TL OT,

873: OTA_DELEGATE_BOOKINGS D,
874: OTA_BOOKING_STATUS_TYPES S,
875: OTA_BOOKING_STATUS_TYPES_TL ST,
876: OTA_OFFERINGS O,
877: OTA_OFFERINGS_TL OT,
878: OTA_CATEGORY_USAGES C,
879: OTA_CATEGORY_USAGES_TL CT,
880: OTA_ACTIVITY_VERSIONS_TL OAV,
881: OTA_EVALUATIONS EVAL

Line 1051: OTA_OFFERINGS O,

1047: OTA_EVENTS_TL ET,
1048: OTA_DELEGATE_BOOKINGS D,
1049: OTA_BOOKING_STATUS_TYPES S,
1050: OTA_BOOKING_STATUS_TYPES_TL ST,
1051: OTA_OFFERINGS O,
1052: OTA_OFFERINGS_TL OT,
1053: OTA_CATEGORY_USAGES C,
1054: OTA_CATEGORY_USAGES_TL CT,
1055: OTA_ACTIVITY_VERSIONS_TL OAV,

Line 1052: OTA_OFFERINGS_TL OT,

1048: OTA_DELEGATE_BOOKINGS D,
1049: OTA_BOOKING_STATUS_TYPES S,
1050: OTA_BOOKING_STATUS_TYPES_TL ST,
1051: OTA_OFFERINGS O,
1052: OTA_OFFERINGS_TL OT,
1053: OTA_CATEGORY_USAGES C,
1054: OTA_CATEGORY_USAGES_TL CT,
1055: OTA_ACTIVITY_VERSIONS_TL OAV,
1056: OTA_EVALUATIONS EVAL

Line 1289: OTA_OFFERINGS O,

1285: OTA_EVENTS_TL ET,
1286: OTA_DELEGATE_BOOKINGS D,
1287: OTA_BOOKING_STATUS_TYPES S,
1288: OTA_BOOKING_STATUS_TYPES_TL ST,
1289: OTA_OFFERINGS O,
1290: OTA_OFFERINGS_TL OT,
1291: OTA_CATEGORY_USAGES C,
1292: OTA_CATEGORY_USAGES_TL CT,
1293: OTA_ACTIVITY_VERSIONS_TL OAV,

Line 1290: OTA_OFFERINGS_TL OT,

1286: OTA_DELEGATE_BOOKINGS D,
1287: OTA_BOOKING_STATUS_TYPES S,
1288: OTA_BOOKING_STATUS_TYPES_TL ST,
1289: OTA_OFFERINGS O,
1290: OTA_OFFERINGS_TL OT,
1291: OTA_CATEGORY_USAGES C,
1292: OTA_CATEGORY_USAGES_TL CT,
1293: OTA_ACTIVITY_VERSIONS_TL OAV,
1294: OTA_EVALUATIONS EVAL