eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QCR01USR_XMLP_PKG dependencies on GMD_QC_TESTS

Line 41: GMD_QC_TESTS_B

37: SELECT
38: TEST_UNIT
39: INTO QCUNIT
40: FROM
41: GMD_QC_TESTS_B
42: WHERE TEST_CODE = ASSAY_CODE;
43: EXCEPTION
44: WHEN NO_DATA_FOUND THEN
45: RETURN (NULL);

Line 71: GMD_QC_TESTS

67: SELECT
68: '[' || TEST_DESC || ']'
69: INTO ASSAYDESC
70: FROM
71: GMD_QC_TESTS
72: WHERE TEST_CODE = ASSAY_CODE;
73: RETURN (ASSAYDESC);
74: EXCEPTION
75: WHEN OTHERS THEN

Line 91: GMD_QC_TESTS_B

87: SELECT
88: MIN_VALUE_NUM
89: INTO ACCEPTABLE_RANGE
90: FROM
91: GMD_QC_TESTS_B
92: WHERE TEST_CODE = ASSAY_CODE;
93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN
95: RETURN (ACCEPTABLE_RANGE);

Line 122: GMD_QC_TESTS_B

118: SELECT
119: MAX_VALUE_NUM
120: INTO ACCEPTABLE_RANGE
121: FROM
122: GMD_QC_TESTS_B
123: WHERE TEST_CODE = ASSAY_CODE;
124: EXCEPTION
125: WHEN NO_DATA_FOUND THEN
126: RETURN (ACCEPTABLE_RANGE);

Line 184: GMD_QC_TESTS

180: SELECT
181: '[' || TEST_DESC || ']'
182: INTO ASSAYDESC
183: FROM
184: GMD_QC_TESTS
185: WHERE TEST_CODE = ASSAY_CODE2;
186: RETURN (ASSAYDESC);
187: EXCEPTION
188: WHEN OTHERS THEN

Line 202: GMD_QC_TESTS_B

198: SELECT
199: TEST_UNIT
200: INTO QCUNIT
201: FROM
202: GMD_QC_TESTS_B
203: WHERE TEST_CODE = ASSAY_CODE2;
204: EXCEPTION
205: WHEN NO_DATA_FOUND THEN
206: RETURN (NULL);

Line 238: GMD_QC_TESTS_B

234: SELECT
235: MIN_VALUE_NUM
236: INTO ACCEPTABLE_RANGE
237: FROM
238: GMD_QC_TESTS_B
239: WHERE TEST_CODE = ASSAY_CODE2;
240: EXCEPTION
241: WHEN NO_DATA_FOUND THEN
242: RETURN (ACCEPTABLE_RANGE);

Line 269: GMD_QC_TESTS_B

265: SELECT
266: MAX_VALUE_NUM
267: INTO ACCEPTABLE_RANGE
268: FROM
269: GMD_QC_TESTS_B
270: WHERE TEST_CODE = ASSAY_CODE2;
271: EXCEPTION
272: WHEN NO_DATA_FOUND THEN
273: RETURN (ACCEPTABLE_RANGE);

Line 905: GMD_QC_TESTS_B

901: DISTINCT
902: TEST_TYPE
903: INTO ASSAYTYPE
904: FROM
905: GMD_QC_TESTS_B
906: WHERE TEST_CODE = ASSAY_CODE;
907: IF ASSAYTYPE = 'L' THEN
908: BEGIN
909: SELECT

Line 1035: GMD_QC_TESTS_B

1031: DISTINCT
1032: TEST_TYPE
1033: INTO ASSAYTYPE
1034: FROM
1035: GMD_QC_TESTS_B
1036: WHERE TEST_CODE = ASSAY_CODE2;
1037: IF ASSAYTYPE = 'L' THEN
1038: BEGIN
1039: SELECT