DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_MR_ROUTES_V

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

1462: IF p_prd_workorder_rec.mr_route_id IS not NULL OR
1463: p_prd_workorder_rec.mr_route_id<>FND_API.G_MISS_NUM THEN
1464: SELECT COUNT(*)
1465: INTO l_dummy_ctr
1466: FROM AHL_MR_ROUTES_V -- Chnaged from AHL_MR_ROUTES to be Application Usage complaint.
1467: WHERE mr_route_id=p_prd_workorder_rec.mr_route_id;
1468:
1469: IF NVL(l_dummy_ctr,0)>1 OR NVL(l_dummy_ctr,0)=0 THEN
1470: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_MR_ROUTE_ID_INVLD');