DBA Data[Home] [Help]

APPS.GME_FPL_PVT dependencies on GMD_RECIPES

Line 46: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

42:
43: CURSOR cur_get_info_from_validity (v_validity_rule_id NUMBER)
44: IS
45: SELECT r.recipe_id, r.routing_id, r.formula_id
46: FROM gmd_recipes_b r, gmd_recipe_validity_rules v
47: WHERE v.recipe_validity_rule_id = v_validity_rule_id
48: AND v.recipe_id = r.recipe_id;
49:
50: CURSOR validity_process_loss_cursor (v_recipe_validity_rule_id NUMBER)

Line 65: FROM gmd_recipes

61:
62: CURSOR recipe_process_loss_cursor (v_recipe_id NUMBER)
63: IS
64: SELECT fixed_process_loss, fixed_process_loss_uom
65: FROM gmd_recipes
66: WHERE recipe_id = v_recipe_id;
67:
68: CURSOR routing_process_loss_cursor (v_routing_id NUMBER)
69: IS