[Home] [Help]
605: WHERE osp_order_id = c_osp_order_id;
606: */
607:
608: CURSOR get_instance_from_id_csr(c_instance_id IN NUMBER) IS
609: SELECT instance_number FROM csi_item_instances
610: WHERE instance_id = c_instance_id;
611:
612: --osp_line_details_rec get_line_details_csr%ROWTYPE;
613:
672: SELECT order_type_code FROM ahl_osp_orders_b
673: WHERE osp_order_id = c_osp_order_id;
674:
675: CURSOR get_instance_from_id_csr(c_instance_id IN NUMBER) IS
676: SELECT instance_number FROM csi_item_instances
677: WHERE instance_id = c_instance_id;
678:
679: osp_line_details_rec get_line_details_csr%ROWTYPE;
680:
726: SELECT order_type_code from ahl_osp_orders_b
727: WHERE osp_order_id = c_osp_order_id;
728:
729: CURSOR get_serial_from_instance_csr(c_instance_id IN NUMBER) IS
730: SELECT serial_number FROM csi_item_instances
731: WHERE instance_id = c_instance_id;
732:
733: cursor get_serial_from_oelsn_csr IS
734: SELECT FROM_SERIAL_NUMBER from oe_lot_serial_numbers
802: SELECT order_type_code from ahl_osp_orders_b
803: WHERE osp_order_id = c_osp_order_id;
804:
805: CURSOR get_lot_num_from_instance_csr(c_instance_id IN NUMBER) IS
806: SELECT lot_number FROM csi_item_instances
807: WHERE instance_id = c_instance_id;
808:
809: cursor get_lot_num_from_oelsn_csr IS
810: SELECT LOT_NUMBER from oe_lot_serial_numbers
864: p_serial_number IN VARCHAR2,
865: p_lot_number IN VARCHAR2) RETURN VARCHAR2 IS
866: CURSOR get_wo_instance_csr IS
867: SELECT csi.instance_number
868: FROM AHL_WORKORDERS WO, AHL_VISITS_VL VST, AHL_VISIT_TASKS_VL VTS, CSI_ITEM_INSTANCES CSI
869: WHERE WO.WORKORDER_ID = p_workorder_id AND
870: WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
871: VST.VISIT_ID = VTS.VISIT_ID AND
872: NVL(VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID) = CSI.INSTANCE_ID;
871: VST.VISIT_ID = VTS.VISIT_ID AND
872: NVL(VTS.INSTANCE_ID, VST.ITEM_INSTANCE_ID) = CSI.INSTANCE_ID;
873:
874: CURSOR get_instance_from_sl_csr IS
875: SELECT instance_number FROM CSI_ITEM_INSTANCES
876: WHERE serial_number = p_serial_number;
877:
878: CURSOR get_instance_from_lot_csr IS
879: SELECT instance_number FROM csi_item_instances
875: SELECT instance_number FROM CSI_ITEM_INSTANCES
876: WHERE serial_number = p_serial_number;
877:
878: CURSOR get_instance_from_lot_csr IS
879: SELECT instance_number FROM csi_item_instances
880: WHERE lot_number = p_lot_number;
881:
882: l_instance_number VARCHAR2(30) := null;
883: