APPS.GME_GANTT_PKG dependencies on GMD_RECIPE_VALIDITY_RULES

Line 174: ,gmd_recipe_validity_rules v

170: IS
171: SELECT i.inventory_item_id, i.concatenated_segments, i.description
172: FROM mtl_system_items_kfv i
173: ,gme_batch_header b
174: ,gmd_recipe_validity_rules v
175: WHERE b.batch_id = p_batch_id
176: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id
177: AND v.inventory_item_id = i.inventory_item_id
178: AND b.organization_id = i.organization_id;

Line 1301: FROM gme_batch_header b, gmd_recipe_validity_rules v

1297: CURSOR get_ids (p_batch_id NUMBER)
1298: IS
1299: SELECT b.formula_id, b.routing_id, b.recipe_validity_rule_id
1300: ,v.recipe_id
1301: FROM gme_batch_header b, gmd_recipe_validity_rules v
1302: WHERE b.batch_id = p_batch_id
1303: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id(+);
1304:
1305: CURSOR get_routing_info (p_routing_id NUMBER)