DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on MTL_ITEM_LOCATIONS

Line 360: from mtl_item_locations

356: end if;
357: end if;
358: if l_locator is not null then
359: select count(*) into l_count
360: from mtl_item_locations
361: where organization_id = p_organization_id and inventory_location_id = l_locator and subinventory_code = l_subinventory;
362: if (l_count = 0) then
363: FND_MESSAGE.set_name('EAM', 'EAM_NOT_VALID_LOCATOR_ID');
364: p_x_return_status := FND_API.G_RET_STS_ERROR;