APPS.GME_MATERIAL_DETAIL_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 32: FROM gmd_recipe_validity_rules

28: l_config_id NUMBER;
29: CURSOR recipe_validity_rule_cursor (v_recipe_validity_rule_id NUMBER)
30: IS
31: SELECT recipe_id
32: FROM gmd_recipe_validity_rules
33: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;
34:
35: error_dbl EXCEPTION;
36: error_processing EXCEPTION;

Line 4233: FROM gmd_recipe_validity_rules

4229: line_type = v_line_type;
4230:
4231: CURSOR c_prim_prod(v_rule_id NUMBER, v_det_id NUMBER) IS
4232: SELECT 1
4233: FROM gmd_recipe_validity_rules
4234: WHERE recipe_validity_rule_id = v_rule_id
4235: AND inventory_item_id = (SELECT inventory_item_id
4236: FROM gme_material_details
4237: WHERE material_detail_id = v_det_id);

Line 4243: FROM gme_batch_header h, gmd_recipe_validity_rules r

4239: /*CURSOR cur_parent_phant (v_batch_id NUMBER, v_item_id NUMBER) IS
4240: SELECT 1
4241: FROM sys.DUAL
4242: WHERE EXISTS ( SELECT 1
4243: FROM gme_batch_header h, gmd_recipe_validity_rules r
4244: WHERE h.batch_id = v_batch_id
4245: AND h.recipe_validity_rule_id = r.recipe_validity_rule_id
4246: AND r.item_id = v_item_id
4247: AND h.parentline_id > 0); */