[Home] [Help]
173: AND (p_item.main_obj_type.organization_id IS NOT NULL
174: AND p_item.main_obj_type.organization_id <> fnd_api.g_miss_num)) THEN
175:
176: SELECT approval_status INTO l_approval_status
177: FROM mtl_system_items_b
178: WHERE inventory_item_id = l_inventory_item_id
179: AND organization_id = p_item.main_obj_type.organization_id;
180:
181: END IF;