DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on MTL_ITEM_LOCATIONS

Line 362: from mtl_item_locations

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