The following lines contain the word 'select', 'insert', 'update' or 'delete':
select SERVICE_ID, SERVICE_HANDLE, SERVICE_NAME
from fnd_cp_services_VL
where
((service_handle like 'XDPA%') or (service_handle like 'XDPQ%')) and
ENABLED = 'Y' and
service_handle <> 'XDPCTRLS'
order by service_handle;
SELECT xar.channel_name, fe.fulfillment_element_name, xar.adapter_display_name,
xar.fe_id, xar.adapter_status, xar.process_id
FROM xdp_adapter_reg xar, xdp_fes fe
WHERE xar.adapter_status not in (XDP_ADAPTER.pv_statusStopped,
XDP_ADAPTER.pv_statusStoppedError,
XDP_ADAPTER.pv_statusTerminated,
XDP_ADAPTER.pv_statusNotAvailable,
XDP_ADAPTER.pv_statusDeactivated,
XDP_ADAPTER.pv_statusDeactivatedSystem)
-- and xar.startup_mode = XDP_ADAPTER.pv_startAutomatic
and xar.fe_id = fe.fe_id
order by fe.fulfillment_element_name;
-- Following package with also update the adapter instance entry
-- in XDP_ADAPTER_REG table accordingly
-- and will submit a admin request if required i.e. if the
-- Adapter cannot be locked
FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||
v_AdapterData.adapter_display_name);
-- and also update the adapter instance entry
-- in XDP_ADAPTER_REG table accordingly
FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||
v_AdapterData.adapter_display_name||
' in abort mode');
l_ServiceInstanceList.delete;
l_ServiceInstanceStarted.delete;
l_ServiceInstanceList.delete;
SELECT xar.channel_name, xfe.fulfillment_element_name,
xar.adapter_display_name, xar.startup_mode, xar.fe_id, xar.adapter_status
FROM xdp_adapter_reg xar, xdp_fes xfe
WHERE xar.adapter_status in (XDP_ADAPTER.pv_statusStopped,
XDP_ADAPTER.pv_statusStoppedError,
XDP_ADAPTER.pv_statusTerminated,
XDP_ADAPTER.pv_statusDeactivated,
XDP_ADAPTER.pv_statusDeactivatedSystem)
and xar.startup_mode in (XDP_ADAPTER.pv_startAutomatic,
XDP_ADAPTER.pv_startGroup,
XDP_ADAPTER.pv_startOnDemand)
and xfe.fe_id = xar.fe_id
order by xfe.fulfillment_element_name;
l_SIProcessList.delete;
select a.concurrent_queue_id, b.concurrent_queue_name
from fnd_concurrent_processes a, fnd_concurrent_queues b
where a.concurrent_process_id = CPID and
a.concurrent_queue_id = b.concurrent_queue_id and
a.queue_application_id = b.application_id;
select a.concurrent_queue_name
from fnd_concurrent_queues a
where a.concurrent_queue_id = ConcQID and
a.application_id = 535;
select a.concurrent_queue_id
from fnd_concurrent_queues a
where upper(a.concurrent_queue_name) = upper(ConcQName);
select count(*)count, msg_state
from AQ$XDP_ORDER_PROCESSOR_QTAB
group by msg_state;
select count(*)count, status_code
from xdp_order_headers
group by status_code;
select count(*)count, msg_state
from AQ$XDP_WORKITEM_QTAB
group by msg_state;
select count(*)count, status_code
from XDP_FULFILL_WORKLIST
group by status_code;
select count(*)count, msg_state
from AQ$XDP_FA_QTAB
group by msg_state;
select count(*)count, status_code
from XDP_FA_RUNTIME_LIST
group by status_code;
select count(*)count,msg_state
from AQ$XDP_WF_CHANNEL_QTAB
group by msg_state;
select count(*)count, msg_state
from AQ$XNP_IN_TMR_QTAB
group by msg_state;
select count(*)count, status
FROM XNP_TIMER_REGISTRY
group by status;
select count(*)count, msg_state
from AQ$XNP_IN_EVT_QTAB
group by msg_state;
select count(*)count,msg_state
from AQ$XNP_IN_MSG_QTAB
group by msg_state;
select count(*)count, msg_state
from AQ$XNP_OUT_MSG_QTAB
group by msg_state;
select count(*)count, msg_status, direction_indicator
from XNP_MSGS
group by msg_status, direction_indicator;
select count(*)
into l_fa_ready_future
from XDP_FA_RUNTIME_LIST
where status_code = 'WAITING_FOR_RESOURCE';
select count(*)
into l_timer_future
from XNP_IN_TMR_QTAB
where nvl(time_manager_info,SYSDATE) > SYSDATE;
select count(*)
into l_event_future
from xnp_callback_events xce,
xnp_msg_types_b xmt
where xce.msg_code = xmt.msg_code and
xce.status = 'WAITING' and
xmt.msg_type IN ('EVENT', 'EVT_NOHEAD');
select count(*)
into l_in_future
from xnp_callback_events xce,
xnp_msg_types_b xmt
where xce.msg_code = xmt.msg_code and
xce.status = 'WAITING' and
xmt.msg_type = 'MSG' and
xmt.queue_name = 'XNP_IN_MSG_Q';