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 287: -- Update FND dictionary: FND_ORACLE_USERID

283: END LOOP;
284:
285:
286:
287: -- Update FND dictionary: FND_ORACLE_USERID
288:
289: delete from FND_ORACLE_USERID
290: where oracle_id =
291: ( select oracle_id from FND_PRODUCT_INSTALLATIONS where application_id = x_appl_id)

Line 289: delete from FND_ORACLE_USERID

285:
286:
287: -- Update FND dictionary: FND_ORACLE_USERID
288:
289: delete from FND_ORACLE_USERID
290: where oracle_id =
291: ( select oracle_id from FND_PRODUCT_INSTALLATIONS where application_id = x_appl_id)
292: and oracle_username = l_schema_name;
293:

Line 328: FROM fnd_oracle_userid

324: Begin
325:
326: SELECT oracle_username
327: INTO l_apps_oracle_name
328: FROM fnd_oracle_userid
329: WHERE oracle_id BETWEEN 900 and 999
330: and read_only_flag = 'U';
331:
332: exception

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

332: exception
333: when no_data_found then
334: raise_application_error(-20001,
335: 'oracle_username for APPS does not'
336: ||' exist in fnd_oracle_userid. ');
337: end;
338:
339: -- dbms_output.put_line('l_apps_oracle_name: ' || l_apps_oracle_name);
340: