[Home] [Help]
2336: SELECT 'x'
2337: FROM ahl_workorders wo,
2338: wip_discrete_jobs wdj,
2339: bom_departments bmd,
2340: ahl_visits_b vst,
2341: ahl_visit_tasks_b vts,
2342: inv_organization_info_v org
2343: WHERE wo.workorder_id = p_workorder_id
2344: AND wo.master_workorder_flag = 'N'
2517: p_workorder_id IN NUMBER,
2518: p_service_item_id IN NUMBER
2519: )IS
2520: CURSOR val_service_item_id_inv_csr(p_service_item_id IN VARCHAR2, p_workorder_id IN NUMBER) IS
2521: SELECT 'x' FROM mtl_system_items_kfv MTL, ahl_workorders WO, AHL_VISITS_B VST
2522: WHERE MTL.inventory_item_id = p_service_item_id
2523: AND MTL.enabled_flag = G_YES_FLAG
2524: AND MTL.inventory_item_flag = G_NO_FLAG
2525: AND MTL.stock_enabled_flag = G_NO_FLAG
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
4408: */
4409: SELECT vst.organization_id, vts.inventory_item_id, arb.service_item_id
4410: INTO l_organization_id, l_inventory_item_id, l_service_item_id
4411: FROM ahl_workorders wo,
4412: ahl_visits_b vst,
4413: ahl_visit_tasks_b vts,
4414: ahl_routes_b arb,
4415: inv_organization_info_v org
4416: WHERE wo.workorder_id = p_x_osp_order_lines_tbl (i).workorder_id
4777: arb.service_item_id,
4778: mtls.description service_item_description,
4779: mtls.primary_uom_code service_item_uom
4780: FROM ahl_workorders wo,
4781: ahl_visits_b vst,
4782: ahl_visit_tasks_b vts,
4783: csi_item_instances csii,
4784: mtl_system_items_kfv mtls,
4785: ahl_routes_b arb
5428: arb.service_item_id,
5429: mtls.description service_item_description,
5430: mtls.primary_uom_code service_item_uom
5431: FROM ahl_workorders wo,
5432: ahl_visits_b vst,
5433: ahl_visit_tasks_b vts,
5434: csi_item_instances csii,
5435: mtl_system_items_kfv mtls,
5436: ahl_routes_b arb
6947: ospl.attribute14,
6948: ospl.attribute15
6949: FROM ahl_osp_order_lines ospl,
6950: ahl_workorders wo,
6951: ahl_visits_b vst,
6952: ahl_visit_tasks_b vts,
6953: csi_item_instances csiwo,
6954: csi_item_instances csiex,
6955: --po_lines_all pl,