[Home] [Help]
2744:
2745: -------------------------------------------------------------------------------------------------------------
2746: PROCEDURE validate_exchange_instance_id(p_exchange_instance_id IN NUMBER) IS
2747: CURSOR val_instance_id_csr(p_instance_id IN NUMBER) IS
2748: SELECT 'x' FROM csi_item_instances csi
2749: WHERE instance_id = p_instance_id
2750: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
2751: AND NOT EXISTS (select subject_id from csi_ii_relationships where
2752: subject_id = p_instance_id and
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
4786: WHERE wo.workorder_id = c_workorder_id
4787: AND wo.visit_task_id = vts.visit_task_id
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
5437: WHERE workorder_id = c_workorder_id
5438: AND wo.visit_task_id = vts.visit_task_id
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,
6956: mtl_units_of_measure_tl mtluom
6957: WHERE ospl.osp_order_line_id = p_x_osp_order_line_rec.osp_order_line_id
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,
6956: mtl_units_of_measure_tl mtluom
6957: WHERE ospl.osp_order_line_id = p_x_osp_order_line_rec.osp_order_line_id
6958: AND ospl.object_version_number= p_x_osp_order_line_rec.object_version_number
7387: -- jaramana End
7388: l_osp_order_line_id NUMBER;
7389: CURSOR exchange_instance_id_csr(p_exchange_instance_number IN VARCHAR2) IS
7390: SELECT instance_id
7391: FROM csi_item_instances
7392: WHERE instance_number = p_exchange_instance_number;
7393: l_exchange_instance_id NUMBER;
7394: CURSOR physical_item_id_csr(p_item_number IN VARCHAR2, p_inventory_org_id NUMBER) IS
7395: SELECT MTL.inventory_item_id