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_CATEGORY_USAGES

Line 780: ota_category_usages c

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
784: AND e.event_id= et.event_id

Line 877: OTA_CATEGORY_USAGES C,

873: OTA_BOOKING_STATUS_TYPES S,
874: OTA_BOOKING_STATUS_TYPES_TL ST,
875: OTA_OFFERINGS O,
876: OTA_OFFERINGS_TL OT,
877: OTA_CATEGORY_USAGES C,
878: OTA_CATEGORY_USAGES_TL CT,
879: OTA_ACTIVITY_VERSIONS_TL OAV,
880: OTA_EVALUATIONS EVAL
881: WHERE a.activity_version_id = e.activity_version_id

Line 878: OTA_CATEGORY_USAGES_TL CT,

874: OTA_BOOKING_STATUS_TYPES_TL ST,
875: OTA_OFFERINGS O,
876: OTA_OFFERINGS_TL OT,
877: OTA_CATEGORY_USAGES C,
878: OTA_CATEGORY_USAGES_TL CT,
879: OTA_ACTIVITY_VERSIONS_TL OAV,
880: OTA_EVALUATIONS EVAL
881: WHERE a.activity_version_id = e.activity_version_id
882: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID

Line 1050: OTA_CATEGORY_USAGES C,

1046: OTA_BOOKING_STATUS_TYPES S,
1047: OTA_BOOKING_STATUS_TYPES_TL ST,
1048: OTA_OFFERINGS O,
1049: OTA_OFFERINGS_TL OT,
1050: OTA_CATEGORY_USAGES C,
1051: OTA_CATEGORY_USAGES_TL CT,
1052: OTA_ACTIVITY_VERSIONS_TL OAV,
1053: OTA_EVALUATIONS EVAL
1054: WHERE a.activity_version_id = e.activity_version_id

Line 1051: OTA_CATEGORY_USAGES_TL CT,

1047: OTA_BOOKING_STATUS_TYPES_TL ST,
1048: OTA_OFFERINGS O,
1049: OTA_OFFERINGS_TL OT,
1050: OTA_CATEGORY_USAGES C,
1051: OTA_CATEGORY_USAGES_TL CT,
1052: OTA_ACTIVITY_VERSIONS_TL OAV,
1053: OTA_EVALUATIONS EVAL
1054: WHERE a.activity_version_id = e.activity_version_id
1055: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID

Line 1286: OTA_CATEGORY_USAGES C,

1282: OTA_BOOKING_STATUS_TYPES S,
1283: OTA_BOOKING_STATUS_TYPES_TL ST,
1284: OTA_OFFERINGS O,
1285: OTA_OFFERINGS_TL OT,
1286: OTA_CATEGORY_USAGES C,
1287: OTA_CATEGORY_USAGES_TL CT,
1288: OTA_ACTIVITY_VERSIONS_TL OAV,
1289: OTA_EVALUATIONS EVAL
1290: WHERE a.activity_version_id = e.activity_version_id

Line 1287: OTA_CATEGORY_USAGES_TL CT,

1283: OTA_BOOKING_STATUS_TYPES_TL ST,
1284: OTA_OFFERINGS O,
1285: OTA_OFFERINGS_TL OT,
1286: OTA_CATEGORY_USAGES C,
1287: OTA_CATEGORY_USAGES_TL CT,
1288: OTA_ACTIVITY_VERSIONS_TL OAV,
1289: OTA_EVALUATIONS EVAL
1290: WHERE a.activity_version_id = e.activity_version_id
1291: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID