APPS.GME_REROUTE_BATCH_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

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 (

Line 883: FROM gmd_recipe_validity_rules v

879: ,v_qty IN NUMBER
880: ,v_laboratory_ind IN NUMBER)
881: IS
882: SELECT COUNT (1)
883: FROM gmd_recipe_validity_rules v
884: WHERE recipe_validity_rule_id = v_validity_rule_id
885: AND ( (validity_rule_status BETWEEN 700 AND 799)
886: OR (validity_rule_status BETWEEN 900 AND 999)
887: OR ( v_laboratory_ind = 1

Line 903: ,gmd_recipe_validity_rules v

899: SELECT d.inventory_item_id, d.organization_id, d.plan_qty
900: ,d.dtl_um line_um, msib.primary_uom_code item_um
901: FROM gme_material_details d
902: ,mtl_system_items_b msib
903: ,gmd_recipe_validity_rules v
904: WHERE d.batch_id = v_batch_id
905: AND d.line_type = 1
906: AND msib.inventory_item_id = d.inventory_item_id
907: AND msib.organization_id = d.organization_id