APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_MTL_ITEMS_OU_V

Line 2408: from ahl_workorders_osp_v wo, ahl_mtl_items_ou_v mtl

2404: AND service_item_id IS NULL;
2405:
2406: CURSOR item_exists_in_wo_org_csr(p_workorder_id IN NUMBER) IS
2407: SELECT 'x'
2408: from ahl_workorders_osp_v wo, ahl_mtl_items_ou_v mtl
2409: where wo.workorder_id = p_workorder_id and
2410: wo.service_item_id = mtl.inventory_item_id and
2411: mtl.inventory_org_id = wo.organization_id;
2412: l_exist VARCHAR2(1);

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

2544: AND ARB.service_item_id IS NULL;
2545:
2546: CURSOR item_exists_in_wo_org_csr(p_workorder_id IN NUMBER) IS
2547: SELECT 'x'
2548: from ahl_workorders WO, AHL_ROUTES_B ARB, AHL_VISITS_B VST, ahl_mtl_items_ou_v mtl
2549: where wo.workorder_id = p_workorder_id and
2550: WO.ROUTE_ID = ARB.ROUTE_ID (+) and
2551: ARB.service_item_id = mtl.inventory_item_id and
2552: VST.visit_id = WO.visit_id and