APPS.OKC_AQ_PVT SQL Statements

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

Line: 30

SELECT acn_type
FROM okc_actions_b
WHERE correlation = p_corrid;

Line: 487

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';

Line: 502

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';*/

Line: 560

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';

Line: 574

/*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';*/

Line: 640

    SELECT name
    FROM   AQ$OKC_AQ_EV_TAB_S
    WHERE  queue = substr(OKC_AQ_PVT.g_event_queue_name,5);

Line: 732

    SELECT name
    FROM   AQ$OKC_AQ_EV_TAB_S
    WHERE  queue = substr(OKC_AQ_PVT.g_outcome_queue_name,5);

Line: 847

  SELECT acn.id id
  FROM   okc_actions_b acn
  WHERE  acn.correlation = l_corrid.corrid;

Line: 1593

  SELECT consumer_name,corr_id
  FROM   aq$okc_aq_ev_tab
  WHERE  msg_id = HEXTORAW(p_msg_id);

Line: 1750

  SELECT consumer_name,corr_id,queue
  FROM   aq$okc_aq_ev_tab
  WHERE  msg_id = HEXTORAW(p_msg_id);

Line: 1882

  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';

Line: 1891

  SELECT msgid
  FROM   okc_aq_ev_tab
  WHERE  q_name = 'AQ$_OKC_AQ_EV_TAB_E'
  AND    trunc(enq_time) + (x) = trunc(sysdate);