[Home] [Help]
2723:
2724: -------------------------------------------------------------------------------------------------------------
2725: PROCEDURE validate_exchange_instance_id(p_exchange_instance_id IN NUMBER) IS
2726: CURSOR val_instance_id_csr(p_instance_id IN NUMBER) IS
2727: SELECT 'x' FROM csi_item_instances csi
2728: WHERE instance_id = p_instance_id
2729: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
2730: AND NOT EXISTS (select subject_id from csi_ii_relationships where
2731: subject_id = p_instance_id and
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
4444: WHERE wo.workorder_id = c_workorder_id
4445: AND wo.visit_task_id = vts.visit_task_id
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
5087: WHERE workorder_id = c_workorder_id
5088: AND wo.visit_task_id = vts.visit_task_id
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,
6507: mtl_units_of_measure_tl mtluom
6508: WHERE ospl.osp_order_line_id = p_x_osp_order_line_rec.osp_order_line_id
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,
6507: mtl_units_of_measure_tl mtluom
6508: WHERE ospl.osp_order_line_id = p_x_osp_order_line_rec.osp_order_line_id
6509: AND ospl.object_version_number= p_x_osp_order_line_rec.object_version_number
6938: -- jaramana End
6939: l_osp_order_line_id NUMBER;
6940: CURSOR exchange_instance_id_csr(p_exchange_instance_number IN VARCHAR2) IS
6941: SELECT instance_id
6942: FROM csi_item_instances
6943: WHERE instance_number = p_exchange_instance_number;
6944: l_exchange_instance_id NUMBER;
6945: CURSOR physical_item_id_csr(p_item_number IN VARCHAR2, p_inventory_org_id NUMBER) IS
6946: SELECT MTL.inventory_item_id