APPS.GME_REROUTE_BATCH_PVT dependencies on GMD_RECIPES

Line 45: FROM gmd_recipe_validity_rules v, gmd_recipes r

41: l_formula_master fm_form_mst%ROWTYPE;
42: CURSOR cur_get_recipe (v_validity_rule_id IN NUMBER)
43: IS
44: SELECT r.recipe_id, r.routing_id, calculate_step_quantity,v.inventory_item_id
45: FROM gmd_recipe_validity_rules v, gmd_recipes r
46: WHERE recipe_validity_rule_id = v_validity_rule_id
47: AND r.recipe_id = v.recipe_id;
48:
49: CURSOR cur_get_max_step_date

Line 739: FROM gmd_recipe_validity_rules grvr, gmd_recipes gr

735:
736: CURSOR cur_get_validity_rule_details (v_validity_rule_id IN NUMBER)
737: IS
738: SELECT gr.formula_id, grvr.inventory_item_id
739: FROM gmd_recipe_validity_rules grvr, gmd_recipes gr
740: WHERE grvr.recipe_validity_rule_id = v_validity_rule_id
741: AND gr.recipe_id = grvr.recipe_id;
742:
743: CURSOR cur_get_material_details (