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_EXCEPTIONS

Line 216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;

212: select count(*) into l_rows_end from FND_LOG_METRICS;
213: ---dbms_output.put_line('FND_LOG_METRICS:dlt rows out of sync'||(l_rows_end-l_rows_start));
214: commit;
215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in
218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );
219: select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;
220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));

Line 217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in

213: ---dbms_output.put_line('FND_LOG_METRICS:dlt rows out of sync'||(l_rows_end-l_rows_start));
214: commit;
215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in
218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );
219: select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;
220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
221: commit;

Line 219: select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;

215:
216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in
218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );
219: select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;
220: ---dbms_output.put_line('FND_LOG_EXCEPTIONS: dlt rows out of sync'||(l_rows_end-l_rows_start));
221: commit;
222:
223:

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

216: select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;
217: delete from FND_LOG_EXCEPTIONS where LOG_SEQUENCE not in
218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );
219: select count(*) into l_rows_end from FND_LOG_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;

Line 226: (select distinct UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );

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;
230: