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_CME_UTIL dependencies on OTA_CATEGORY_USAGES

Line 319: ota_category_usages ocu

315: SELECT evt.activity_version_id,
316: ocu.online_flag
317: FROM ota_events evt,
318: ota_offerings ofr,
319: ota_category_usages ocu
320: WHERE evt.event_id = p_event_id
321: AND evt.parent_offering_id = ofr.offering_id
322: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
323:

Line 349: l_online_flag ota_category_usages.online_flag%type;

345: -- don't consider expired prds
346: AND cpe.period_status_code <> 'EXPIRED';
347:
348: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
349: l_online_flag ota_category_usages.online_flag%type;
350: l_enroll_type ota_booking_status_types.type%TYPE;
351: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
352: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
353: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

Line 898: ota_category_usages c

894: ota_cert_prd_enrollments cpe,
895: ota_cert_mbr_enrollments cme,
896: ota_certification_members cmb,
897: ota_offerings ofr,
898: ota_category_usages c
899: WHERE e.event_id = b.event_id
900: AND cre.cert_enrollment_id = cpe.cert_enrollment_id
901: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
902: AND e.event_id= et.event_id