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_MESSAGES

Line 196: select count(*) into l_rows_start from FND_LOG_MESSAGES;

192: ( SELECT REQUEST_ID from FND_CONCURRENT_REQUESTS where REQUEST_ID=TRANSACTION_ID);
193:
194: --Deletes data for which no transaction context info is available.
195: ---dbms_output.put_line('IN:SYNC_EXP_DATA');
196: select count(*) into l_rows_start from FND_LOG_MESSAGES;
197: delete from FND_LOG_MESSAGES where
198: TRANSACTION_CONTEXT_ID not in
199: (select distinct TRANSACTION_CONTEXT_ID from
200: FND_LOG_TRANSACTION_CONTEXT)

Line 197: delete from FND_LOG_MESSAGES where

193:
194: --Deletes data for which no transaction context info is available.
195: ---dbms_output.put_line('IN:SYNC_EXP_DATA');
196: select count(*) into l_rows_start from FND_LOG_MESSAGES;
197: delete from FND_LOG_MESSAGES where
198: TRANSACTION_CONTEXT_ID not in
199: (select distinct TRANSACTION_CONTEXT_ID from
200: FND_LOG_TRANSACTION_CONTEXT)
201: ;

Line 202: select count(*) into l_rows_end from FND_LOG_MESSAGES;

198: TRANSACTION_CONTEXT_ID not in
199: (select distinct TRANSACTION_CONTEXT_ID from
200: FND_LOG_TRANSACTION_CONTEXT)
201: ;
202: select count(*) into l_rows_end from FND_LOG_MESSAGES;
203: ---dbms_output.put_line('FND_LOG_MESSAGES:dlt rows out of sync'||(l_rows_end-l_rows_start));
204: commit;
205:
206: select count(*) into l_rows_start from FND_LOG_METRICS;

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

199: (select distinct TRANSACTION_CONTEXT_ID from
200: FND_LOG_TRANSACTION_CONTEXT)
201: ;
202: select count(*) into l_rows_end from FND_LOG_MESSAGES;
203: ---dbms_output.put_line('FND_LOG_MESSAGES:dlt rows out of sync'||(l_rows_end-l_rows_start));
204: commit;
205:
206: select count(*) into l_rows_start from FND_LOG_METRICS;
207: delete from FND_LOG_METRICS where

Line 218: (select distinct LOG_SEQUENCE from FND_LOG_MESSAGES );

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