APPS.XDP_FQUEUE_TOOLS SQL Statements

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

Line: 8

     SELECT count(1)
     INTO   entries_number
     FROM   xdp_pending_order_qtab;

Line: 12

     SELECT count(1)
     INTO   entries_number
     FROM   XDP_ORDER_PROCESSOR_qtab;

Line: 16

     SELECT count(1)
     INTO   entries_number
     FROM   xdp_workitem_qtab;

Line: 20

     SELECT count(1)
     INTO   entries_number
     FROM   xdp_fa_qtab;

Line: 24

     SELECT count(1)
     INTO   entries_number
     FROM   xdp_adapter_job_queue;

Line: 28

     SELECT count(1)
     INTO   entries_number
     FROM   xdp_wf_channel_qtab;

Line: 32

     SELECT count(1)
     INTO   entries_number
     FROM   XDP_ADAPTER_ADMIN_REQS; */

Line: 36

     SELECT count(1)
     INTO   entries_number
     FROM   xnp_in_msg_qtab;

Line: 40

     SELECT count(1)
     INTO   entries_number
     FROM   xnp_out_msg_qtab;

Line: 44

     SELECT count(1)
     INTO   entries_number
     FROM   xnp_in_evt_qtab;

Line: 48

     SELECT count(1)
     INTO   entries_number
     FROM   xnp_in_tmr_qtab;

Line: 58

     SELECT max(ENQ_TIME)
     INTO   entry_date
     FROM   xdp_pending_order_qtab;

Line: 62

     SELECT max(ENQ_TIME)
     INTO   entry_date
     FROM   XDP_ORDER_PROCESSOR_qtab;

Line: 66

     SELECT max(ENQ_TIME)
     INTO   entry_date
     FROM   xdp_workitem_qtab;

Line: 70

     SELECT max(ENQ_TIME)
     INTO   entry_date
     FROM   xdp_fa_qtab;

Line: 74

     SELECT max(QUEUED_ON)
     INTO   entry_date
     FROM   xdp_adapter_job_queue;

Line: 78

     SELECT max(enq_time)
     INTO   entry_date
     FROM   xdp_wf_channel_qtab;

Line: 82

     SELECT max(REQUEST_DATE)
     INTO   entry_date
     FROM   XDP_ADAPTER_ADMIN_REQS; */

Line: 86

     SELECT max(ENQ_TIME)
     INTO   entry_date
     FROM   xnp_in_msg_qtab;

Line: 90

     SELECT max(ENQ_TIME)
     INTO   entry_date
     FROM   xnp_out_msg_qtab;

Line: 94

     SELECT max(ENQ_TIME)
     INTO   entry_date
     FROM   xnp_in_evt_qtab;

Line: 104

     SELECT count(1)
     INTO   procs_number
     FROM   xdp_dqer_registration
     WHERE  internal_q_name = queued_id;