[Home] [Help]
2315: SELECT 'x'
2316: FROM ahl_workorders wo,
2317: wip_discrete_jobs wdj,
2318: bom_departments bmd,
2319: ahl_visits_b vst,
2320: ahl_visit_tasks_b vts,
2321: inv_organization_info_v org
2322: WHERE wo.workorder_id = p_workorder_id
2323: AND wo.master_workorder_flag = 'N'
2496: p_workorder_id IN NUMBER,
2497: p_service_item_id IN NUMBER
2498: )IS
2499: CURSOR val_service_item_id_inv_csr(p_service_item_id IN VARCHAR2, p_workorder_id IN NUMBER) IS
2500: SELECT 'x' FROM mtl_system_items_kfv MTL, ahl_workorders WO, AHL_VISITS_B VST
2501: WHERE MTL.inventory_item_id = p_service_item_id
2502: AND MTL.enabled_flag = G_YES_FLAG
2503: AND MTL.inventory_item_flag = G_NO_FLAG
2504: AND MTL.stock_enabled_flag = G_NO_FLAG
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
4066: */
4067: SELECT vst.organization_id, vts.inventory_item_id, arb.service_item_id
4068: INTO l_organization_id, l_inventory_item_id, l_service_item_id
4069: FROM ahl_workorders wo,
4070: ahl_visits_b vst,
4071: ahl_visit_tasks_b vts,
4072: ahl_routes_b arb,
4073: inv_organization_info_v org
4074: WHERE wo.workorder_id = p_x_osp_order_lines_tbl (i).workorder_id
4435: arb.service_item_id,
4436: mtls.description service_item_description,
4437: mtls.primary_uom_code service_item_uom
4438: FROM ahl_workorders wo,
4439: ahl_visits_b vst,
4440: ahl_visit_tasks_b vts,
4441: csi_item_instances csii,
4442: mtl_system_items_kfv mtls,
4443: ahl_routes_b arb
5078: arb.service_item_id,
5079: mtls.description service_item_description,
5080: mtls.primary_uom_code service_item_uom
5081: FROM ahl_workorders wo,
5082: ahl_visits_b vst,
5083: ahl_visit_tasks_b vts,
5084: csi_item_instances csii,
5085: mtl_system_items_kfv mtls,
5086: ahl_routes_b arb
6498: ospl.attribute14,
6499: ospl.attribute15
6500: FROM ahl_osp_order_lines ospl,
6501: ahl_workorders wo,
6502: ahl_visits_b vst,
6503: ahl_visit_tasks_b vts,
6504: csi_item_instances csiwo,
6505: csi_item_instances csiex,
6506: --po_lines_all pl,