APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_MR_ROUTES_V

Line 1598: FROM AHL_MR_ROUTES_V -- Chnaged from AHL_MR_ROUTES to be Application Usage complaint.

1594: IF p_prd_workorder_rec.mr_route_id IS not NULL OR
1595: p_prd_workorder_rec.mr_route_id<>FND_API.G_MISS_NUM THEN
1596: SELECT COUNT(*)
1597: INTO l_dummy_ctr
1598: FROM AHL_MR_ROUTES_V -- Chnaged from AHL_MR_ROUTES to be Application Usage complaint.
1599: WHERE mr_route_id=p_prd_workorder_rec.mr_route_id;
1600:
1601: IF NVL(l_dummy_ctr,0)>1 OR NVL(l_dummy_ctr,0)=0 THEN
1602: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MR_ROUTE_ID_INVLD');