DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 186: FROM mtl_system_items_b

182: AND (p_item.main_obj_type.organization_id IS NOT NULL
183: AND p_item.main_obj_type.organization_id <> fnd_api.g_miss_num)) THEN
184:
185: SELECT approval_status INTO l_item_approval_status
186: FROM mtl_system_items_b
187: WHERE inventory_item_id = l_inventory_item_id
188: AND organization_id = p_item.main_obj_type.organization_id;
189:
190: END IF;