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_EBI_RECIPE_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 24: SELECT inventory_item_id FROM mtl_system_items_b WHERE

20: FUNCTION item_exists_in_org(p_item_id IN NUMBER,p_org_id IN NUMBER)
21: RETURN VARCHAR2
22: IS
23: CURSOR check_item_exists IS
24: SELECT inventory_item_id FROM mtl_system_items_b WHERE
25: inventory_item_id= p_item_id AND organization_id= p_org_id;
26: l_item_id NUMBER;
27: BEGIN
28: IF (check_item_exists%ISOPEN) THEN

Line 91: SELECT recipe_enabled_flag INTO l_temp FROM mtl_system_items_b WHERE inventory_item_id=p_formula_obj.formula_details(j).inventory_item_id

87: ,p_item_number => p_formula_obj.formula_details(j).item_no
88: ,p_org_id_tbl=>l_org_id_tbl
89: ,x_out=>l_out
90: );
91: SELECT recipe_enabled_flag INTO l_temp FROM mtl_system_items_b WHERE inventory_item_id=p_formula_obj.formula_details(j).inventory_item_id
92: AND organization_id=p_formula_obj.formula_details(j).owner_organization_id;
93:
94: IF (l_out.output_status.return_status NOT IN(FND_API.G_RET_STS_SUCCESS,'Q')) THEN
95: x_msg_data := l_out.output_status.msg_data || ' FOR FORMULA' || p_formula_obj.formula_header.FORMULA_NO || p_formula_obj.formula_details(j).LINE_NO || p_formula_obj.formula_details(j).LINE_TYPE;