The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT acn_type
FROM okc_actions_b
WHERE correlation = p_corrid;
SELECT h.msgid msgid ,
decode(h.subscriber#,0
,decode(h.name,'0',NULL,h.name),s.name) consumer_name
from AQ$_OKC_AQ_EV_TAB_H h,
aq$_okc_aq_ev_tab_s s,
okc_aq_ev_tab q
WHERE q.q_name = substr(p_queue,5)
and q.STATE = 0
and h.msgid = q.msgid
AND ( (h.subscriber# <> 0 AND h.subscriber# = s.subscriber_id)
OR
(h.subscriber# = 0 AND h.address# = s.subscriber_id))
AND q.CORRID = 'SHUTDOWN';
SELECT msg_id,consumer_name
FROM aq$okc_aq_ev_tab
WHERE 'OKC.'||queue = p_queue
AND msg_state = 'READY'
AND UPPER(corr_id) = 'SHUTDOWN';*/
SELECT h.msgid msgid ,
decode(h.subscriber#,0
,decode(h.name,'0',NULL,h.name),s.name) consumer_name
from AQ$_OKC_AQ_EV_TAB_H h,
aq$_okc_aq_ev_tab_s s,
okc_aq_ev_tab q
WHERE q.q_name = substr(p_queue,5)
and q.STATE = 0
and h.msgid = q.msgid
AND ( (h.subscriber# <> 0 AND h.subscriber# = s.subscriber_id)
OR
(h.subscriber# = 0 AND h.address# = s.subscriber_id))
AND q.CORRID = 'SHUTDOWN';
/*SELECT msg_id,consumer_name
FROM aq$okc_aq_ev_tab
WHERE 'OKC.'||queue = p_queue
AND msg_state = 'READY'
AND UPPER(corr_id) = 'SHUTDOWN';*/
SELECT name
FROM AQ$OKC_AQ_EV_TAB_S
WHERE queue = substr(OKC_AQ_PVT.g_event_queue_name,5);
SELECT name
FROM AQ$OKC_AQ_EV_TAB_S
WHERE queue = substr(OKC_AQ_PVT.g_outcome_queue_name,5);
SELECT acn.id id
FROM okc_actions_b acn
WHERE acn.correlation = l_corrid.corrid;
SELECT consumer_name,corr_id
FROM aq$okc_aq_ev_tab
WHERE msg_id = HEXTORAW(p_msg_id);
SELECT consumer_name,corr_id,queue
FROM aq$okc_aq_ev_tab
WHERE msg_id = HEXTORAW(p_msg_id);
SELECT opval.profile_option_value profile_value
FROM fnd_profile_options op,
fnd_profile_option_values opval
WHERE op.profile_option_id = opval.profile_option_id
AND op.application_id = opval.application_id
AND op.profile_option_name = 'OKC_RETAIN_MSG_DAYS';
SELECT msgid
FROM okc_aq_ev_tab
WHERE q_name = 'AQ$_OKC_AQ_EV_TAB_E'
AND trunc(enq_time) + (x) = trunc(sysdate);