APPS.AHL_PRD_WORKORDER_PVT dependencies on MTL_ITEM_LOCATIONS
Line 1576: FROM MTL_ITEM_LOCATIONS
1572: IF p_prd_workorder_rec.Completion_locator_id IS not NULL AND
1573: p_prd_workorder_rec.Completion_locator_id<>FND_API.G_MISS_CHAR THEN
1574: SELECT COUNT(*)
1575: INTO l_dummy_ctr 1576: FROM MTL_ITEM_LOCATIONS 1577: WHERE inventory_location_id=p_prd_workorder_rec.completion_locator_id;
1578: IF l_dummy_ctr =0 THEN
1579: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_COMPLSUBINV_INVALID');
1580: FND_MSG_PUB.ADD;