782: SELECT
783: DISPLAY_LABEL_NUMERIC_RANGE
784: INTO ASSAYVALUE
785: FROM
786: GMD_QC_TEST_VALUES
787: WHERE TEST_ID = QCASSY_TYP_ID
788: AND ( MIN_NUM <= NUM_RESULT
789: OR MIN_NUM IS NULL )
790: AND ( MAX_NUM >= NUM_RESULT
820: SELECT
821: DISPLAY_LABEL_NUMERIC_RANGE
822: INTO ASSAYVALUE
823: FROM
824: GMD_QC_TEST_VALUES
825: WHERE TEST_ID = QCASSY_TYP_ID
826: AND ( MIN_NUM <= TARGETSPECCF
827: OR MIN_NUM IS NULL )
828: AND ( MAX_NUM >= TARGETSPECCF
846: SELECT
847: DISPLAY_LABEL_NUMERIC_RANGE
848: INTO ASSAYVALUE
849: FROM
850: GMD_QC_TEST_VALUES
851: WHERE TEST_ID = QCASSY_TYP_ID
852: AND ( MIN_NUM <= MIN_SPECCF
853: OR MIN_NUM IS NULL )
854: AND ( MAX_NUM >= MIN_SPECCF
870: SELECT
871: DISPLAY_LABEL_NUMERIC_RANGE
872: INTO ASSAYVALUE
873: FROM
874: GMD_QC_TEST_VALUES
875: WHERE TEST_ID = QCASSY_TYP_ID
876: AND ( MIN_NUM <= MAX_SPECCF
877: OR MIN_NUM IS NULL )
878: AND ( MAX_NUM >= MAX_SPECCF