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_AME_ATTRIBUTES dependencies on OTA_CATEGORY_USAGES_VL

Line 197: ota_category_usages_vl ocu,

193:
194: cursor c_get_course_category is
195: Select ocu.Category
196: From ota_act_cat_inclusions oaci,
197: ota_category_usages_vl ocu,
198: ota_events oev,
199: ota_offerings ofr
200: Where oev.event_id = c_event_id
201: AND oev.parent_offering_id = ofr.offering_id

Line 311: ota_category_usages_vl ocu

307:
308: cursor c_get_ofr_dm is
309: Select ocu.Category
310: From ota_offerings ofr,
311: ota_category_usages_vl ocu
312: Where ofr.offering_id = c_offering_id
313: AND ofr.delivery_mode_id = ocu.category_usage_id
314: AND ocu.type = 'DM'
315: AND (TRUNC(sysdate) BETWEEN NVL(TRUNC(ocu.start_date_active), TRUNC(sysdate))