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 224: ota_category_usages ocu

220: SELECT evt.activity_version_id,
221: ocu.online_flag
222: FROM ota_events evt,
223: ota_offerings ofr,
224: ota_category_usages ocu
225: WHERE evt.event_id = p_event_id
226: AND evt.parent_offering_id = ofr.offering_id
227: AND OFR.DELIVERY_MODE_ID = ocu.CATEGORY_USAGE_ID;
228:

Line 254: l_online_flag ota_category_usages.online_flag%type;

250: -- don't consider expired prds
251: AND cpe.period_status_code <> 'EXPIRED';
252:
253: l_activity_version_id ota_activity_versions.activity_version_id%TYPE;
254: l_online_flag ota_category_usages.online_flag%type;
255: l_enroll_type ota_booking_status_types.type%TYPE;
256: l_member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE;
257: l_completion_date ota_cert_mbr_enrollments.completion_date%TYPE;
258: l_date_status_changed ota_delegate_bookings.date_status_changed%TYPE;

Line 786: ota_category_usages c

782: ota_cert_prd_enrollments cpe,
783: ota_cert_mbr_enrollments cme,
784: ota_certification_members cmb,
785: ota_offerings ofr,
786: ota_category_usages c
787: WHERE e.event_id = b.event_id
788: AND cre.cert_enrollment_id = cpe.cert_enrollment_id
789: AND cpe.cert_prd_enrollment_id = cme.cert_prd_enrollment_id
790: AND e.event_id= et.event_id