DBA Data[Home] [Help]

APPS.GMD_QCR01USR_XMLP_PKG dependencies on GMD_QC_TEST_VALUES

Line 913: GMD_QC_TEST_VALUES

909: SELECT
910: DISPLAY_LABEL_NUMERIC_RANGE
911: INTO ASSAYVALUE
912: FROM
913: GMD_QC_TEST_VALUES
914: WHERE TEST_ID = QCASSY_TYP_ID
915: AND ( MIN_NUM <= TARGETCF
916: OR MIN_NUM IS NULL )
917: AND ( MAX_NUM >= TARGETCF

Line 938: GMD_QC_TEST_VALUES

934: SELECT
935: DISPLAY_LABEL_NUMERIC_RANGE
936: INTO ASSAYVALUE
937: FROM
938: GMD_QC_TEST_VALUES
939: WHERE TEST_ID = QCASSY_TYP_ID
940: AND ( MIN_NUM <= MIN_SPECCF
941: OR MIN_NUM IS NULL )
942: AND ( MAX_NUM >= MIN_SPECCF

Line 961: GMD_QC_TEST_VALUES

957: SELECT
958: DISPLAY_LABEL_NUMERIC_RANGE
959: INTO ASSAYVALUE
960: FROM
961: GMD_QC_TEST_VALUES
962: WHERE TEST_ID = QCASSY_TYP_ID
963: AND ( MIN_NUM <= MAX_SPECCF
964: OR MIN_NUM IS NULL )
965: AND ( MAX_NUM >= MAX_SPECCF

Line 984: GMD_QC_TEST_VALUES

980: SELECT
981: DISPLAY_LABEL_NUMERIC_RANGE
982: INTO ASSAYVALUE
983: FROM
984: GMD_QC_TEST_VALUES
985: WHERE TEST_ID = QCASSY_TYP_ID1
986: AND ( MIN_NUM <= MAX_SPEC1CF
987: OR MIN_NUM IS NULL )
988: AND ( MAX_NUM >= MAX_SPEC1CF

Line 1008: GMD_QC_TEST_VALUES

1004: SELECT
1005: DISPLAY_LABEL_NUMERIC_RANGE
1006: INTO ASSAYVALUE
1007: FROM
1008: GMD_QC_TEST_VALUES
1009: WHERE TEST_ID = QCASSY_TYP_ID1
1010: AND ( MIN_NUM <= MIN_SPEC1CF
1011: OR MIN_NUM IS NULL )
1012: AND ( MAX_NUM >= MIN_SPEC1CF

Line 1043: GMD_QC_TEST_VALUES

1039: SELECT
1040: DISPLAY_LABEL_NUMERIC_RANGE
1041: INTO ASSAYVALUE
1042: FROM
1043: GMD_QC_TEST_VALUES
1044: WHERE TEST_ID = QCASSY_TYP_ID1
1045: AND ( MIN_NUM <= TARGET1CF
1046: OR MIN_NUM IS NULL )
1047: AND ( MAX_NUM >= TARGET1CF

Line 1067: GMD_QC_TEST_VALUES

1063: SELECT
1064: DISPLAY_LABEL_NUMERIC_RANGE
1065: INTO ASSAYVALUE
1066: FROM
1067: GMD_QC_TEST_VALUES
1068: WHERE TEST_ID = QCASSY_TYP_ID1
1069: AND ( MIN_NUM <= NUM_RESULT2
1070: OR MIN_NUM IS NULL )
1071: AND ( MAX_NUM >= NUM_RESULT2

Line 1090: GMD_QC_TEST_VALUES

1086: SELECT
1087: distinct DISPLAY_LABEL_NUMERIC_RANGE -- 12575637 added distinct
1088: INTO ASSAYVALUE
1089: FROM
1090: GMD_QC_TEST_VALUES
1091: WHERE TEST_ID = QCASSY_TYP_ID
1092: AND ( MIN_NUM <= NUM_RESULT
1093: OR MIN_NUM IS NULL )
1094: AND ( MAX_NUM >= NUM_RESULT