DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on MTL_ITEM_LOCATIONS

Line 1444: FROM MTL_ITEM_LOCATIONS

1440: IF p_prd_workorder_rec.Completion_locator_id IS not NULL AND
1441: p_prd_workorder_rec.Completion_locator_id<>FND_API.G_MISS_CHAR THEN
1442: SELECT COUNT(*)
1443: INTO l_dummy_ctr
1444: FROM MTL_ITEM_LOCATIONS
1445: WHERE inventory_location_id=p_prd_workorder_rec.completion_locator_id;
1446: IF l_dummy_ctr =0 THEN
1447: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_COMPLSUBINV_INVALID');
1448: FND_MSG_PUB.ADD;