APPS.CS_ROUTING_UTL SQL Statements

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

Line: 30

      SELECT customer_id
      FROM   cs_incidents_all
      WHERE  incident_number = p_request_number;

Line: 71

      SELECT customer_id
      FROM   cs_customer_products_all
      WHERE  current_serial_number = p_serial_number;

Line: 109

      SELECT customer_id
      FROM   cs_systems_all_vl
      WHERE  name = p_system_name;

Line: 149

      SELECT customer_product_id
      FROM   cs_incidents_all
      WHERE  incident_number = p_request_number;

Line: 193

      SELECT customer_product_id
      FROM   cs_customer_products_all
      WHERE  current_serial_number = p_serial_number;

Line: 232

      SELECT inventory_item_id
      FROM   cs_incidents_all
      WHERE  incident_number = p_request_number;

Line: 271

      SELECT inventory_item_id
      FROM   cs_customer_products_all
      WHERE  current_serial_number = p_serial_number;

Line: 309

      SELECT employee_id
      FROM   cs_incidents_all
      WHERE  incident_number = p_request_number;

Line: 352

      SELECT incident_type_id
      FROM   cs_incidents_all
      WHERE  incident_number = p_incident_number;

Line: 360

      SELECT DISTINCT cgla.role_person_id
      FROM   cs_group_level_assigns cgla
      WHERE  (cgla.sr_type_id = v_incident_type_id AND
              cgla.role_person_orig_system = 'PER')
      UNION
      SELECT DISTINCT paf.person_id
      FROM cs_group_level_assigns cgla,
           per_assignments_f paf
      WHERE (cgla.sr_type_id = v_incident_type_id AND
            cgla.role_person_orig_system = 'POS' AND
            paf.position_id = cgla.role_person_id);