APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_MTL_ITEMS_OU_V

Line 2387: from ahl_workorders_osp_v wo, ahl_mtl_items_ou_v mtl

2383: AND service_item_id IS NULL;
2384:
2385: CURSOR item_exists_in_wo_org_csr(p_workorder_id IN NUMBER) IS
2386: SELECT 'x'
2387: from ahl_workorders_osp_v wo, ahl_mtl_items_ou_v mtl
2388: where wo.workorder_id = p_workorder_id and
2389: wo.service_item_id = mtl.inventory_item_id and
2390: mtl.inventory_org_id = wo.organization_id;
2391: l_exist VARCHAR2(1);

Line 2527: from ahl_workorders WO, AHL_ROUTES_B ARB, AHL_VISITS_B VST, ahl_mtl_items_ou_v mtl

2523: AND ARB.service_item_id IS NULL;
2524:
2525: CURSOR item_exists_in_wo_org_csr(p_workorder_id IN NUMBER) IS
2526: SELECT 'x'
2527: from ahl_workorders WO, AHL_ROUTES_B ARB, AHL_VISITS_B VST, ahl_mtl_items_ou_v mtl
2528: where wo.workorder_id = p_workorder_id and
2529: WO.ROUTE_ID = ARB.ROUTE_ID (+) and
2530: ARB.service_item_id = mtl.inventory_item_id and
2531: VST.visit_id = WO.visit_id and