APPS.GME_GANTT_PKG dependencies on GMD_RECIPE_VALIDITY_RULES

Line 217: ,gmd_recipe_validity_rules v

213: IS
214: SELECT i.inventory_item_id, i.concatenated_segments, i.description
215: FROM mtl_system_items_kfv i
216: ,gme_batch_header b
217: ,gmd_recipe_validity_rules v
218: WHERE b.batch_id = p_batch_id
219: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id
220: AND v.inventory_item_id = i.inventory_item_id
221: AND b.organization_id = i.organization_id;

Line 1791: FROM gme_batch_header b, gmd_recipe_validity_rules v

1787: CURSOR get_ids (p_batch_id NUMBER)
1788: IS
1789: SELECT b.formula_id, b.routing_id, b.recipe_validity_rule_id
1790: ,v.recipe_id
1791: FROM gme_batch_header b, gmd_recipe_validity_rules v
1792: WHERE b.batch_id = p_batch_id
1793: AND b.recipe_validity_rule_id = v.recipe_validity_rule_id(+);
1794:
1795: CURSOR get_routing_info (p_routing_id NUMBER)