The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
CNT
FROM
( SELECT
count(*) CNT
FROM
XTR_MARKET_DATA_INTERFACE
WHERE RETURN_CODE >= 50
UNION ALL
SELECT
count(*) CNT
FROM
XTR_MARKET_DATA_INTERFACE
WHERE RETURN_CODE < 40
UNION ALL
SELECT
count(*) CNT
FROM
XTR_MARKET_DATA_INTERFACE
WHERE RETURN_CODE = 40 );
SELECT
ITEM_NAME,
SUBSTR(TEXT
,1
,100) LANG_NAME
FROM
XTR_SYS_LANGUAGES_VL
WHERE MODULE_NAME = 'XTRMDTRP';
SELECT
FCPV.USER_CONCURRENT_PROGRAM_NAME,
FCR.PROGRAM_APPLICATION_ID
INTO P_REPORT_TITLE,V_APP_ID
FROM
FND_CONCURRENT_PROGRAMS_VL FCPV,
FND_CONCURRENT_REQUESTS FCR
WHERE FCR.REQUEST_ID = P_CONC_REQUEST_ID
AND FCPV.APPLICATION_ID = FCR.PROGRAM_APPLICATION_ID
AND FCPV.CONCURRENT_PROGRAM_ID = FCR.CONCURRENT_PROGRAM_ID;
SELECT
FORM_LEFT_PROMPT
INTO P_ERRORS_ONLY_LABEL
FROM
FND_DESCR_FLEX_COL_USAGE_VL
WHERE APPLICATION_ID = V_APP_ID
AND DESCRIPTIVE_FLEXFIELD_NAME = '$SRS$.XTRMDTRP'
AND SRW_PARAM = 'P_ERRORS_ONLY';