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_EXCEPTION_NOTES

Line 232: select count(*) into l_rows_start from FND_EXCEPTION_NOTES;

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;
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));

Line 233: delete from FND_EXCEPTION_NOTES where UNIQUE_EXCEPTION_ID not in

229: commit;
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;

Line 235: select count(*) into l_rows_end from FND_EXCEPTION_NOTES;

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:
239:

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

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:
239:
240: select count(*) into l_rows_start from FND_OAM_BIZEX_SENT_NOTIF;