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_DEFINITIONS

Line 200: FROM ota_activity_definitions tad

196: -- ----------------------------------------------------------------------------
197: function do_create_ctg_for_tad return boolean is
198: cursor c_exist is
199: select 1
200: FROM ota_activity_definitions tad
201: WHERE tad.category_usage_id is null
202: AND rownum = 1 ;
203:
204: l_exists boolean := false;

Line 225: from ota_activity_definitions tad

221: select 1
222: from ota_category_usages ocu
223: where ocu.type = 'C'
224: and not exists (select category_usage_id
225: from ota_activity_definitions tad
226: where tad.category_usage_id is not null
227: and tad.category_usage_id = ocu.category_usage_id)
228: and rownum = 1 ;
229:

Line 460: ,'OTA_ACTIVITY_DEFINITIONS'

456: write_log('Creating category for activity');
457: l_upgrade_done := true;
458: submit_upgrade( 'ota_classic_upgrade.create_category_for_activity'
459: ,get_upgrade_name(ACTIVITY_TO_CATEGORY,CONC_UPGRADE_ID)
460: ,'OTA_ACTIVITY_DEFINITIONS'
461: ,'ACTIVITY_ID');
462: end if;
463:
464: