APPS.FND_LOG_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

          select PHASE_CODE into l_phase_code
          from FND_CONCURRENT_REQUESTS
          where REQUEST_ID=trId;

Line: 51

          select  count(*) into l_audsid_count
          from GV$SESSION
          where AUDSID=trId;

Line: 59

          select  PROCESS_STATUS_CODE into l_process_status_code
          from FND_CONCURRENT_PROCESSES
          where  CONCURRENT_PROCESS_ID=trId;

Line: 71

                select  LAST_CONNECT into l_last_connect
                from ICX_TRANSACTIONS
                where  TRANSACTION_ID=sessId;

Line: 75

                select  max(LAST_CONNECT) into l_last_connect
                from ICX_TRANSACTIONS
                where  SESSION_ID=sessId;

Line: 135

    select
         distinct fltc.SESSION_ID, fltc.TRANSACTION_CONTEXT_ID, fltc.TRANSACTION_TYPE
      ,  fltc.TRANSACTION_ID
    from
        FND_LOG_TRANSACTION_CONTEXT fltc,
        FND_LOG_METRICS flm
    where
        fltc.TRANSACTION_CONTEXT_ID=flm.TRANSACTION_CONTEXT_ID
    and flm.EVENT_KEY is null;

Line: 190

  delete from FND_LOG_TRANSACTION_CONTEXT where
  TRANSACTION_TYPE = 'REQUEST' AND TRANSACTION_ID<>
  ( SELECT REQUEST_ID from FND_CONCURRENT_REQUESTS  where REQUEST_ID=TRANSACTION_ID);

Line: 196

     select count(*) into l_rows_start from FND_LOG_MESSAGES;

Line: 197

     delete from FND_LOG_MESSAGES where
         TRANSACTION_CONTEXT_ID not in
            (select distinct TRANSACTION_CONTEXT_ID from
               FND_LOG_TRANSACTION_CONTEXT)
      ;

Line: 202

      select count(*) into l_rows_end from FND_LOG_MESSAGES;

Line: 206

     select count(*) into l_rows_start from FND_LOG_METRICS;

Line: 207

     delete from FND_LOG_METRICS where
         TRANSACTION_CONTEXT_ID not in
            (select distinct TRANSACTION_CONTEXT_ID from
               FND_LOG_TRANSACTION_CONTEXT)
      ;

Line: 212

      select count(*) into l_rows_end from FND_LOG_METRICS;

Line: 216

      select count(*) into l_rows_start from FND_LOG_EXCEPTIONS;

Line: 217

      delete from  FND_LOG_EXCEPTIONS  where  LOG_SEQUENCE not in
      (select distinct  LOG_SEQUENCE from FND_LOG_MESSAGES );

Line: 219

      select count(*) into l_rows_end from FND_LOG_EXCEPTIONS;

Line: 224

      select count(*) into l_rows_start from FND_LOG_UNIQUE_EXCEPTIONS;

Line: 225

      delete from  FND_LOG_UNIQUE_EXCEPTIONS  where  UNIQUE_EXCEPTION_ID not in
      (select distinct  UNIQUE_EXCEPTION_ID from FND_LOG_EXCEPTIONS );

Line: 227

      select count(*) into l_rows_end from FND_LOG_UNIQUE_EXCEPTIONS;

Line: 232

      select count(*) into l_rows_start from FND_EXCEPTION_NOTES;

Line: 233

      delete from  FND_EXCEPTION_NOTES  where  UNIQUE_EXCEPTION_ID not in
        (select distinct  UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );

Line: 235

      select count(*) into l_rows_end from FND_EXCEPTION_NOTES;

Line: 240

      select count(*) into l_rows_start from FND_OAM_BIZEX_SENT_NOTIF;

Line: 241

      delete from  FND_OAM_BIZEX_SENT_NOTIF  where  UNIQUE_EXCEPTION_ID not in
        (select distinct  UNIQUE_EXCEPTION_ID from FND_LOG_UNIQUE_EXCEPTIONS );

Line: 243

      select count(*) into l_rows_end from FND_OAM_BIZEX_SENT_NOTIF;