DBA Data[Home] [Help]

APPS.GMD_FORMULA_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 468: FROM mtl_system_items_b

464:
465: FOR j IN 1 .. p_formula_header_tbl.count LOOP
466: BEGIN
467: SELECT segment1,recipe_enabled_flag INTO v_item_no, v_recipe_enabled
468: FROM mtl_system_items_b
469: WHERE (inventory_item_id = NVL(p_formula_header_tbl(j).inventory_item_id, -9999) OR
470: segment1 = p_formula_header_tbl(j).item_no) AND
471: organization_id = p_formula_header_tbl(j).owner_organization_id;
472: EXCEPTION