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_REPROCESS_CLASSIC_UPGRADE dependencies on OTA_ACTIVITY_VERSIONS

Line 249: FROM ota_activity_versions tav

245: -- Select Query is wrong.
246: function do_create_offerings return boolean is
247: cursor c_exist is
248: select 1
249: FROM ota_activity_versions tav
250: WHERE
251: not exists (select 1 from ota_offerings off where off.activity_version_id = tav.activity_version_id )
252: and ( exists (select 1 from ota_events evt where evt.activity_version_id = tav.activity_version_id )
253: or ( exists (select 1 from ota_resource_usages rud where rud.activity_version_id = tav.activity_version_id)

Line 484: ,'OTA_ACTIVITY_VERSIONS'

480: write_log('Creating Offerings');
481: l_upgrade_done := true;
482: submit_upgrade( 'ota_classic_upgrade.create_offering'
483: ,get_upgrade_name(CREATE_OFFERINGS,CONC_UPGRADE_ID)
484: ,'OTA_ACTIVITY_VERSIONS'
485: ,'ACTIVITY_VERSION_ID');
486:
487: update ota_offerings
488: set learning_object_id = null