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.FND_LOG_UTIL dependencies on FND_LOG_UNIQUE_EXCEPTIONS

Line 224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;

220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
221: commit;
222:
223:
224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;
225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in
226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );
227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;
228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));

Line 225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in

221: commit;
222:
223:
224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;
225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in
226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );
227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;
228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
229: commit;

Line 227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;

223:
224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;
225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in
226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );
227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;
228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
229: commit;
230:
231:

Line 228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));

224: select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;
225: delete from FND_LOG_UNIQUE_EXCEPTIONS where UNIQUE_EXCEPTION_ID not in
226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );
227: select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;
228: ---dbms_output.put_line('FND_LOG_UNIQUE_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
229: commit;
230:
231:
232: select count(*) into l_rows_start from FND_EXCEPTION_NOTES;

Line 234: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );

230:
231:
232: select count(*) into l_rows_start from FND_EXCEPTION_NOTES;
233: delete from FND_EXCEPTION_NOTES where UNIQUE_EXCEPTION_ID not in
234: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
235: select count(*) into l_rows_end from FND_EXCEPTION_NOTES;
236: ---dbms_output.put_line('FND_EXCEPTION_NOTES: dlt rows out of sync'||(l_rows_end-l_rows_start));
237: commit;
238:

Line 242: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );

238:
239:
240: select count(*) into l_rows_start from FND_OAM_BIZEX_SENT_NOTIF;
241: delete from FND_OAM_BIZEX_SENT_NOTIF where UNIQUE_EXCEPTION_ID not in
242: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );
243: select count(*) into l_rows_end from FND_OAM_BIZEX_SENT_NOTIF;
244: ---dbms_output.put_line('FND_OAM_BIZEX_SENT_NOTIF: dlt rows out of sync'||(l_rows_end-l_rows_start));
245: commit;
246: