[Home] [Help]
326: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number
327: FROM ahl_workorders wo,
328: ahl_visits_b vst,
329: ahl_visit_tasks_b tsk,
330: csi_item_instances csi
331: WHERE wo.visit_task_id = tsk.visit_task_id
332: AND vst.visit_id = tsk.visit_id
333: AND NVL(tsk.instance_id,vst.item_instance_id)=csi.instance_id
334: AND wo.workorder_id = p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID;
353: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number,x_sr_task_rec.Originating_wo_id
354: FROM AHL_WORKORDERS WO,
355: AHL_VISITS_B VST,
356: AHL_VISIT_TASKS_B TSK,
357: CSI_ITEM_INSTANCES CSI
358: WHERE WO.VISIT_TASK_ID = TSK.VISIT_TASK_ID
359: AND VST.VISIT_ID = TSK.VISIT_ID
360: AND NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)=CSI.INSTANCE_ID
361: AND WO.WORKORDER_NAME = p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER;
493: CURSOR get_instance_details(p_unit_name VARCHAR2)
494: IS
495: SELECT instance_number,
496: serial_number
497: FROM csi_item_instances csi,
498: ahl_unit_config_headers uch
499: WHERE uch.name = p_unit_name
500: AND uch.csi_item_instance_id = csi.instance_id;
501: BEGIN
655:
656: BEGIN
657: SELECT mtl.concatenated_segments,csi.serial_number
658: INTO x_create_nr_output_rec.item_number,x_create_nr_output_rec.serial_number
659: FROm csi_item_instances csi, mtl_system_items_kfv mtl,cs_incidents_all_b cs
660: WHERE csi.instance_id = cs.customer_product_id
661: and csi.inventory_item_id = mtl.inventory_item_id
662: and mtl.organization_id = csi.inv_master_organization_id
663: AND cs.incident_id = p_nr_task_rec.incident_id;
847: END IF;
848: BEGIN
849: SELECT mtl.concatenated_segments,csi.serial_number
850: INTO x_create_nr_output_rec.ITEM_NUMBER,x_create_nr_output_rec.SERIAL_NUMBER
851: FROm csi_item_instances csi, mtl_system_items_kfv mtl
852: WHERE csi.instance_id = p_sr_task_rec.instance_id
853: and csi.inventory_item_id = mtl.inventory_item_id
854: and mtl.organization_id = csi.INV_MASTER_ORGANIZATION_ID;
855: EXCEPTION