APPS.GMD_STATUS_PUB dependencies on GMD_RECIPES

Line 151: FROM gmd_recipes_b

147: CURSOR get_curr_recipe_status(vRecipe_id NUMBER
148: ,vRecipe_no VARCHAR2
149: ,vRecipe_vers NUMBER) IS
150: SELECT recipe_id, recipe_no, recipe_version, recipe_status
151: FROM gmd_recipes_b
152: WHERE ((vRecipe_no IS NULL AND vRecipe_vers IS NULL) AND
153: (recipe_id = vRecipe_id)) OR
154: ((vRecipe_id IS NULL) AND
155: (recipe_no = vRecipe_no AND recipe_version = vRecipe_vers));

Line 212: FROM gmd_recipes r, gmd_recipe_validity_rules vr

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

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

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

Line 945: 'RECIPE','GMD_RECIPES_B',

941: gmd_debug.put_line ('In locked exception section ');
942: END IF;
943: SELECT DECODE(P_entity_name,
944: 'FORMULA','FM_FORM_MST_B',
945: 'RECIPE','GMD_RECIPES_B',
946: 'OPERATION','GMD_OPERATIONS_B',
947: 'ROUTING','GMD_ROUTINGS_B',
948: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES') INTO l_table_name
949: FROM sys.dual;