APPS.GMD_PROCESS_INSTR_UTILS SQL Statements

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

Line: 8

  SELECT r.routing_id, r.formula_id
    FROM gmd_recipes_b r
   WHERE r.recipe_id = v_recipe_id;

Line: 14

  SELECT f.formulaline_id, f.line_no, f.line_type, f.inventory_item_id, i.concatenated_segments
    FROM fm_matl_dtl f, mtl_system_items_kfv i
   WHERE f.formula_id = v_formula_id
     AND f.inventory_item_id = i.inventory_item_id
     AND f.organization_id = i.organization_id
ORDER BY f.line_type, f.line_no;

Line: 23

  SELECT oprn_line_id, activity
    FROM gmd_operation_activities
   WHERE oprn_id = v_oprn_id
ORDER BY oprn_line_id;

Line: 30

  SELECT r.routingstep_id, r.routingstep_no, r.oprn_id, o.oprn_no
    FROM fm_rout_dtl r, gmd_operations_b o
   WHERE r.routing_id = v_routing_id
     AND r.oprn_id = o.oprn_id
ORDER BY r.routingstep_no;

Line: 38

  SELECT oprn_line_id, resources
    FROM gmd_operation_resources
   WHERE oprn_line_id = v_oprn_line_id
ORDER BY resources;

Line: 728

  SELECT oprn_line_id, activity
    FROM gmd_operation_activities
   WHERE oprn_id = v_oprn_id
ORDER BY oprn_line_id;

Line: 735

  SELECT oprn_line_id, resources
    FROM gmd_operation_resources
   WHERE oprn_line_id = v_oprn_line_id
ORDER BY resources;

Line: 741

  SELECT r.routingstep_id,r.oprn_id
    FROM fm_rout_dtl r
   WHERE r.routingstep_id = v_routingstep_id;

Line: 1275

      SELECT formula_id, routing_id ,recipe_id
      FROM   gmd_recipes
      WHERE  recipe_id      = cp_recipe_id;