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 PER_COMPETENCE_ELEMENTS

Line 256: or ( exists ( select 1 from per_competence_elements where object_id = tav.activity_version_id and type = 'TRAINER')

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)
254: and not exists (select 1 from ota_resource_usages rud1 where rud1.activity_version_id= tav.activity_version_id
255: and rud1.offering_id is null))
256: or ( exists ( select 1 from per_competence_elements where object_id = tav.activity_version_id and type = 'TRAINER')
257: and not exists (select 1 from per_competence_elements where object_id = tav.activity_version_id and type = 'OTA_OFFERING')))
258: and rownum =1;
259:
260: cursor c_exist_0 is

Line 257: and not exists (select 1 from per_competence_elements where object_id = tav.activity_version_id and type = 'OTA_OFFERING')))

253: or ( exists (select 1 from ota_resource_usages rud where rud.activity_version_id = tav.activity_version_id)
254: and not exists (select 1 from ota_resource_usages rud1 where rud1.activity_version_id= tav.activity_version_id
255: and rud1.offering_id is null))
256: or ( exists ( select 1 from per_competence_elements where object_id = tav.activity_version_id and type = 'TRAINER')
257: and not exists (select 1 from per_competence_elements where object_id = tav.activity_version_id and type = 'OTA_OFFERING')))
258: and rownum =1;
259:
260: cursor c_exist_0 is
261: select 1