APPS.OKS_IMPORT_REPORT SQL Statements

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

Line: 53

SELECT FL.Meaning		    Statistic_Name,
       INNER_Q.Headers_Stat         Headers_Stat,
       INNER_Q.Lines_Stat           Lines_Stat,
       INNER_Q.Covered_Levels_Stat  Covered_Levels_Stat,
       INNER_Q.Usage_Counters_Stat  Usage_Counters_Stat,
       INNER_Q.Sales_Credits_Stat   Sales_Credits_Stat,
       INNER_Q.Notes_Stat           Notes_Stat
FROM   FND_LOOKUPS  FL,
       (SELECT  OIS.STATISTIC_TYPE_ID        Statistic_type,
                SUM(OIS.HEADERS_STAT)	     Headers_Stat,
                SUM(OIS.LINES_STAT)	     Lines_Stat,
                SUM(OIS.COVERED_LEVELS_STAT) Covered_Levels_Stat,
	        SUM(OIS.USAGE_COUNTERS_STAT) Usage_Counters_Stat,
                SUM(OIS.SALES_CREDITS_STAT)  Sales_Credits_Stat,
	        SUM(OIS.NOTES_STAT)          Notes_Stat
        FROM   OKS_IMPORT_STATISTICS OIS
       WHERE   OIS.PARENT_REQUEST_ID = c_parent_request_id
         AND   OIS.BATCH_ID = c_batch_id
       GROUP BY OIS.STATISTIC_TYPE_ID) INNER_Q
WHERE  FL.LOOKUP_TYPE = 'OKS_IMPORT_STAT_TYPE'
  AND  FL.LOOKUP_CODE = INNER_Q.Statistic_type
ORDER BY INNER_Q.Statistic_type;

Line: 162

  SELECT OIE.INTERFACE_TABLE, OIE.INTERFACE_ID, nvl(FNM.MESSAGE_TEXT, OIE.ERROR_MESSAGE) ERROR_MESSAGE
    FROM OKS_IMP_ERRORS OIE,
         (SELECT FM.* FROM FND_NEW_MESSAGES FM, FND_APPLICATION FA
	  WHERE FM.LANGUAGE_CODE = USERENV('LANG')
            AND FA.APPLICATION_SHORT_NAME = 'OKS' AND FM.APPLICATION_ID = FA.APPLICATION_ID) FNM
   WHERE OIE.ERROR_MESSAGE = FNM.MESSAGE_NAME (+)
     AND PARENT_REQUEST_ID = c_parent_request_id;

Line: 281

 select to_char(actual_start_date, 'DD-MON-YYYY HH24:MI:SS'),
        to_char(actual_completion_date, 'DD-MON-YYYY HH24:MI:SS'),
        to_char(sysdate, 'DD-MON-YYYY HH24:MI')
 into   l_start_date, l_end_date, l_report_date
 from fnd_concurrent_requests
 where request_id = P_parent_request_id;

Line: 290

 select meaning into l_mode from fnd_lookups where lookup_type = 'OKS_IMPORT_MODE' and lookup_code = P_mode;