APPS.GMD_STATUS_PUB dependencies on GMD_RECIPES

Line 147: FROM gmd_recipes_b

143: CURSOR get_curr_recipe_status(vRecipe_id NUMBER
144: ,vRecipe_no VARCHAR2
145: ,vRecipe_vers NUMBER) IS
146: SELECT recipe_id, recipe_no, recipe_version, recipe_status
147: FROM gmd_recipes_b
148: WHERE ((vRecipe_no IS NULL AND vRecipe_vers IS NULL) AND
149: (recipe_id = vRecipe_id)) OR
150: ((vRecipe_id IS NULL) AND
151: (recipe_no = vRecipe_no AND recipe_version = vRecipe_vers));

Line 208: FROM gmd_recipes r, gmd_recipe_validity_rules vr

204:
205: -- Gets the formula associated with the val rule
206: CURSOR get_vr_dets(vVR_id NUMBER) IS
207: SELECT r.formula_id, vr.organization_id
208: FROM gmd_recipes r, gmd_recipe_validity_rules vr
209: WHERE r.recipe_id = vr.recipe_id
210: AND vr.recipe_validity_rule_id = vVR_id;
211:
212: -- Recipe being changed to ON-HOLD - check for less than ON-HOLD and FROZEN

Line 264: FROM mtl_system_items i, gmd_recipe_validity_rules v, gmd_recipes_b re

260: UNION
261: -- Get process ececution enabled setting for the recipe owning orgn
262: -- for Global recipes (Global val rules)
263: SELECT i.process_execution_enabled_flag
264: FROM mtl_system_items i, gmd_recipe_validity_rules v, gmd_recipes_b re
265: WHERE v.recipe_validity_rule_id = V_val_rule_id
266: AND i.inventory_item_id = v.inventory_item_id
267: AND v.recipe_id = re.recipe_id
268: AND i.organization_id = re.owner_organization_id

Line 939: 'RECIPE','GMD_RECIPES_B',

935: gmd_debug.put_line ('In locked exception section ');
936: END IF;
937: SELECT DECODE(P_entity_name,
938: 'FORMULA','FM_FORM_MST_B',
939: 'RECIPE','GMD_RECIPES_B',
940: 'OPERATION','GMD_OPERATIONS_B',
941: 'ROUTING','GMD_ROUTINGS_B',
942: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES') INTO l_table_name
943: FROM sys.dual;