APPS.ECX_INBOUND_ENGINE_QH SQL Statements

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

Line: 35

  select upper(queue_name), upper(name), system_guid
  into   x_queue_name, x_agent_name, x_sys_guid      -- 20
  from   wf_agents
  where  guid = p_agent_guid;

Line: 40

  select upper(name)
  into   x_sys_name
  from   wf_systems
  where  guid = x_sys_guid;

Line: 154

        select ecx_trigger_id_s.NEXTVAL
        from dual;

Line: 174

  select agt.queue_name into x_out_queue
  from   wf_agents  agt,
         wf_systems sys
  where  agt.name = x_out_agent_name
  and    sys.name = x_out_system_name
  and    sys.guid = agt.system_guid;