eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_STATUS_PUB dependencies on MTL_SYSTEM_ITEMS

Line 255: FROM mtl_system_items i, gmd_recipe_validity_rules v

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

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

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