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 878: OTA_CATEGORY_USAGES C,

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
882: WHERE a.activity_version_id = e.activity_version_id

Line 879: OTA_CATEGORY_USAGES_TL CT,

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
882: WHERE a.activity_version_id = e.activity_version_id
883: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID

Line 1053: OTA_CATEGORY_USAGES C,

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
1057: WHERE a.activity_version_id = e.activity_version_id

Line 1054: OTA_CATEGORY_USAGES_TL CT,

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
1057: WHERE a.activity_version_id = e.activity_version_id
1058: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID

Line 1291: OTA_CATEGORY_USAGES C,

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
1295: WHERE a.activity_version_id = e.activity_version_id

Line 1292: OTA_CATEGORY_USAGES_TL CT,

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
1295: WHERE a.activity_version_id = e.activity_version_id
1296: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID