[Home] [Help]
349: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number
350: FROM ahl_workorders wo,
351: ahl_visits_b vst,
352: ahl_visit_tasks_b tsk,
353: csi_item_instances csi
354: WHERE wo.visit_task_id = tsk.visit_task_id
355: AND vst.visit_id = tsk.visit_id
356: AND NVL(tsk.instance_id,vst.item_instance_id)=csi.instance_id
357: AND wo.workorder_id = p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID;
376: INTO x_sr_task_rec.instance_number,x_sr_task_rec.visit_number,x_sr_task_rec.Originating_wo_id
377: FROM AHL_WORKORDERS WO,
378: AHL_VISITS_B VST,
379: AHL_VISIT_TASKS_B TSK,
380: CSI_ITEM_INSTANCES CSI
381: WHERE WO.VISIT_TASK_ID = TSK.VISIT_TASK_ID
382: AND VST.VISIT_ID = TSK.VISIT_ID
383: AND NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)=CSI.INSTANCE_ID
384: AND WO.WORKORDER_NAME = p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER;
508: CURSOR get_instance_details(p_unit_name VARCHAR2)
509: IS
510: SELECT instance_number,
511: serial_number
512: FROM csi_item_instances csi,
513: ahl_unit_config_headers uch
514: WHERE uch.name = p_unit_name
515: AND uch.csi_item_instance_id = csi.instance_id;
516: BEGIN
670:
671: BEGIN
672: SELECT mtl.concatenated_segments,csi.serial_number
673: INTO x_create_nr_output_rec.item_number,x_create_nr_output_rec.serial_number
674: FROm csi_item_instances csi, mtl_system_items_kfv mtl,cs_incidents_all_b cs
675: WHERE csi.instance_id = cs.customer_product_id
676: and csi.inventory_item_id = mtl.inventory_item_id
677: and mtl.organization_id = csi.inv_master_organization_id
678: AND cs.incident_id = p_nr_task_rec.incident_id;
850: END IF;
851: BEGIN
852: SELECT mtl.concatenated_segments,csi.serial_number
853: INTO x_create_nr_output_rec.ITEM_NUMBER,x_create_nr_output_rec.SERIAL_NUMBER
854: FROm csi_item_instances csi, mtl_system_items_kfv mtl
855: WHERE csi.instance_id = p_sr_task_rec.instance_id
856: and csi.inventory_item_id = mtl.inventory_item_id
857: and mtl.organization_id = csi.INV_MASTER_ORGANIZATION_ID;
858: EXCEPTION