APPS.GME_MATERIAL_DETAIL_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 37: FROM gmd_recipe_validity_rules

33:
34: CURSOR recipe_validity_rule_cursor (v_recipe_validity_rule_id NUMBER)
35: IS
36: SELECT recipe_id
37: FROM gmd_recipe_validity_rules
38: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;
39:
40: error_dbl EXCEPTION;
41: error_processing EXCEPTION;

Line 4424: FROM gmd_recipe_validity_rules

4420: line_type = v_line_type;
4421:
4422: CURSOR c_prim_prod(v_rule_id NUMBER, v_det_id NUMBER) IS
4423: SELECT 1
4424: FROM gmd_recipe_validity_rules
4425: WHERE recipe_validity_rule_id = v_rule_id
4426: AND inventory_item_id = (SELECT inventory_item_id
4427: FROM gme_material_details
4428: WHERE material_detail_id = v_det_id);

Line 4434: FROM gme_batch_header h, gmd_recipe_validity_rules r

4430: /*CURSOR cur_parent_phant (v_batch_id NUMBER, v_item_id NUMBER) IS
4431: SELECT 1
4432: FROM sys.DUAL
4433: WHERE EXISTS ( SELECT 1
4434: FROM gme_batch_header h, gmd_recipe_validity_rules r
4435: WHERE h.batch_id = v_batch_id
4436: AND h.recipe_validity_rule_id = r.recipe_validity_rule_id
4437: AND r.item_id = v_item_id
4438: AND h.parentline_id > 0); */