DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on GMD_RECIPES

Line 893: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

889:
890: CURSOR cur_get_info_from_validity (v_validity_rule_id NUMBER)
891: IS
892: SELECT r.recipe_id, r.routing_id, r.formula_id
893: FROM gmd_recipes_b r, gmd_recipe_validity_rules v
894: WHERE v.recipe_validity_rule_id = v_validity_rule_id
895: AND v.recipe_id = r.recipe_id;
896:
897: /*Bug#5618961 cursor modified to select routing class uom instead of

Line 916: FROM gmd_recipes

912:
913: CURSOR recipe_process_loss_cursor (v_recipe_id NUMBER)
914: IS
915: SELECT planned_process_loss
916: FROM gmd_recipes
917: WHERE recipe_id = v_recipe_id;
918:
919: /*Bug#5618961 cursor modified to select routing qty and uom */
920: CURSOR routing_process_loss_cursor (v_routing_id NUMBER)