DBA Data[Home] [Help]

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;