APPS.GMD_STATUS_PUB dependencies on MTL_SYSTEM_ITEMS

Line 259: FROM mtl_system_items i, gmd_recipe_validity_rules v

255: CURSOR Cur_chk_prod_exec_enabled (V_val_rule_id NUMBER) IS
256: -- Get process ececution enabled setting for the val rule orgn
257: -- (Local val rules)
258: SELECT i.process_execution_enabled_flag
259: FROM mtl_system_items i, gmd_recipe_validity_rules v
260: WHERE v.recipe_validity_rule_id = V_val_rule_id
261: AND i.inventory_item_id = v.inventory_item_id
262: AND i.organization_id = v.organization_id
263: AND v.organization_id IS NOT NULL

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 277: FROM fm_matl_dtl f, mtl_system_items i

273: AND v.organization_id IS NULL;
274:
275: CURSOR Cur_experimental_items(V_form_id NUMBER) IS
276: SELECT COUNT(f.inventory_item_id)
277: FROM fm_matl_dtl f, mtl_system_items i
278: WHERE f.formula_id = V_form_id
279: AND f.inventory_item_id = i.inventory_item_id
280: AND f.organization_id = i.organization_id
281: AND i.eng_item_flag = 'Y';