APPS.GME_FPL_PVT SQL Statements

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

Line: 37

         SELECT b.recipe_validity_rule_id, a.recipe_id, b.organization_id
               ,b.routing_id, b.formula_id
           FROM gme_batch_header b, gmd_recipe_validity_rules a
          WHERE b.batch_id = v_batch_id
            AND b.recipe_validity_rule_id = a.recipe_validity_rule_id;

Line: 45

         SELECT r.recipe_id, r.routing_id, r.formula_id
           FROM gmd_recipes_b r, gmd_recipe_validity_rules v
          WHERE v.recipe_validity_rule_id = v_validity_rule_id
            AND v.recipe_id = r.recipe_id;

Line: 52

         SELECT fixed_process_loss, fixed_process_loss_uom
           FROM gmd_recipe_validity_rules
          WHERE recipe_validity_rule_id = NVL (v_recipe_validity_rule_id, -1);

Line: 58

         SELECT fixed_process_loss, fixed_process_loss_uom
           FROM gmd_recipe_process_loss
          WHERE recipe_id = v_recipe_id AND organization_id = v_org_id;

Line: 64

         SELECT fixed_process_loss, fixed_process_loss_uom
           FROM gmd_recipes
          WHERE recipe_id = v_recipe_id;

Line: 70

	         SELECT routing_class, fixed_process_loss, fixed_process_loss_uom
	           FROM gmd_routings_b
	          WHERE routing_id = v_routing_id;

Line: 76

         SELECT b.fixed_process_loss, b.routing_class_uom
           FROM gmd_routings_b a, gmd_routing_class_b b
          WHERE a.routing_id = v_routing_id
            AND a.routing_class = b.routing_class (+);

Line: 247

         SELECT primary_uom_code
         FROM mtl_system_items_kfv
         WHERE inventory_item_id = v_inventory_item_id
         AND organization_id = v_org_id;

Line: 254

         SELECT concatenated_segments
         FROM mtl_system_items_kfv
         WHERE organization_id = v_org_id
         AND inventory_item_id = v_inventory_item_id;

Line: 539

  SELECT   *
  FROM gme_material_details
  WHERE batch_id = v_batch_id
  ORDER BY line_no;

Line: 553

  error_update_batch             EXCEPTION;

Line: 605

         IF NOT gme_batch_header_dbl.update_row
                 (p_batch_header => x_batch_header_rec) THEN
            RAISE error_update_batch;

Line: 612

               gme_debug.put_line('Before calling gme_material_details_dbl.update_row');

Line: 614

            IF NOT (gme_material_details_dbl.update_row (x_material_tbl (i) )) THEN
               RAISE material_save_failed;

Line: 617

               x_material_tbl (i).last_update_date := gme_common_pvt.g_timestamp;

Line: 618

               x_material_tbl (i).last_updated_by := gme_common_pvt.g_user_ident;

Line: 619

               x_material_tbl (i).last_update_login := gme_common_pvt.g_login_id;

Line: 627

WHEN error_update_batch THEN
     x_return_status := FND_API.g_ret_sts_unexp_error;