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.AD_OBSOLETE_PRODUCTS dependencies on FND_ORACLE_USERID

Line 332: -- Update FND dictionary: FND_ORACLE_USERID

328: END LOOP;
329:
330:
331:
332: -- Update FND dictionary: FND_ORACLE_USERID
333:
334: delete from FND_ORACLE_USERID
335: where oracle_id =
336: ( select oracle_id from FND_PRODUCT_INSTALLATIONS where application_id = x_appl_id)

Line 334: delete from FND_ORACLE_USERID

330:
331:
332: -- Update FND dictionary: FND_ORACLE_USERID
333:
334: delete from FND_ORACLE_USERID
335: where oracle_id =
336: ( select oracle_id from FND_PRODUCT_INSTALLATIONS where application_id = x_appl_id)
337: and oracle_username = l_schema_name;
338:

Line 376: FROM fnd_oracle_userid

372: Begin
373:
374: SELECT oracle_username
375: INTO l_apps_oracle_name
376: FROM fnd_oracle_userid
377: WHERE oracle_id BETWEEN 900 and 999
378: and read_only_flag = 'U';
379:
380: exception

Line 384: ||' exist in fnd_oracle_userid. ');

380: exception
381: when no_data_found then
382: raise_application_error(-20001,
383: 'oracle_username for APPS does not'
384: ||' exist in fnd_oracle_userid. ');
385: end;
386:
387: -- dbms_output.put_line('l_apps_oracle_name: ' || l_apps_oracle_name);
388: