The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
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;
select meaning into l_mode from fnd_lookups where lookup_type = 'OKS_IMPORT_MODE' and lookup_code = P_mode;