APPS.XNP_WEB_UTILS SQL Statements

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

Line: 67

  select avg (send_rcv_date - msg_creation_date ) into l_msg_days from xnp_msgs
    where send_rcv_date is not null;

Line: 116

  select count(*)  into l_total_portings from xnp_sv_soa_vl
    where status_phase IN ('ACTIVE', 'OLD');

Line: 119

  select count(*)  into l_inprogress_portings from xnp_sv_soa_vl
    where status_phase IN ('ORDER');

Line: 122

  select count(*)  into l_inquery_portings from xnp_sv_soa_vl
    where status_phase IN ('INQUIRY');

Line: 125

  select count(*)  into l_xdp_workitems from XDP_FULFILL_WORKLIST ;

Line: 200

  select q_alias from XDP_DQ_CONFIGURATION WHERE state = 'DISABLED';

Line: 203

	select text into l_wf_path from wf_resources where name = 'WF_WEB_AGENT';

Line: 206

	select count(*) into l_num1 from WF_NOTIFICATIONS where status = 'OPEN';

Line: 210

	select count(*) into l_num2 from XDP_ADAPTER_REG  where ADAPTER_STATUS = 'ERROR';

Line: 213

	select count(*) into l_num3 from XDP_FULFILL_WORKLIST  where STATUS_CODE = 'ERROR';

Line: 216

	select count(*) into l_num4 from XNP_CALLBACK_EVENTS where status ='WAITING' and MSG_CODE='ADAPTER_READY';

Line: 219

	select count(*) into l_num5 from XNP_MSGS where MSG_STATUS = 'FAILED';

Line: 222

	select count(*) into l_num6 from WF_ITEM_ACTIVITY_STATUSES
    where (ITEM_TYPE like 'XNP%' and ACTIVITY_STATUS = 'ERROR');

Line: 226

	select count(*) into l_num8 from WF_ITEM_ACTIVITY_STATUSES
    where (ITEM_TYPE like 'XDP%' and ACTIVITY_STATUS = 'ERROR');

Line: 234

	--select count(*) into l_num7 from XDP_DQ_CONFIGURATION where state = 'DISABLED';