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_RESULTS_GRP dependencies on GMD_SPEC_TESTS_B

Line 115: --| in select for table - gmd_spec_tests_b |

111: --| Susan Feinstein 10-Mar-2003 allow retained samples to save record|
112: --| in gmd_sample_spec_disp table |
113: --| |
114: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
115: --| in select for table - gmd_spec_tests_b |
116: --| Brenda Stone 21-Aug-2003 Changed cursor c_vrs_vw; removed the |
117: --| use of the view and replaced with |
118: --| UNION ALL of all the spec vr tables |
119: --| to improve performance |

Line 152: FROM gmd_spec_tests_b st, gmd_test_methods_b tm

148: , tm.resources, st.viability_duration
149: , st.test_qty
150: , st.test_qty_uom
151: , tm.test_method_id
152: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
153: WHERE st.spec_id = p_spec_id
154: AND st.exclude_ind IS NULL
155: AND ((p_lot_retest_ind IS NULL) OR
156: (st.retest_lot_expiry_ind = p_lot_retest_ind)

Line 891: --| in select for table - gmd_spec_tests_b |

887: --| HISTORY |
888: --| Chetan Nagar 08-Aug-2002 Created. |
889: --| |
890: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
891: --| in select for table - gmd_spec_tests_b |
892: --| |
893: --+========================================================================+
894: -- End of comments
895:

Line 907: FROM gmd_spec_tests_b st

903:
904: -- Cursors
905: CURSOR c_new_spec_tests (p_spec_id NUMBER) IS
906: SELECT st.test_id
907: FROM gmd_spec_tests_b st
908: WHERE st.spec_id = p_spec_id
909: AND st.exclude_ind IS NULL
910: AND st.test_id NOT IN
911: (SELECT r.test_id

Line 995: --| in select for table - gmd_spec_tests_b |

991: --| HISTORY |
992: --| Chetan Nagar 16-Sep-2002 Created. |
993: --| |
994: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
995: --| in select for table - gmd_spec_tests_b |
996: --| |
997: --+========================================================================+
998: -- End of comments
999:

Line 1011: FROM gmd_spec_tests_b st

1007:
1008: -- Cursors
1009: CURSOR c_new_spec_tests (p_composite_spec_disp_id NUMBER) IS
1010: SELECT st.test_id
1011: FROM gmd_spec_tests_b st
1012: WHERE st.spec_id = p_spec_id
1013: AND st.exclude_ind IS NULL
1014: AND st.test_id NOT IN
1015: (SELECT cr.test_id

Line 1096: --| in select for table - gmd_spec_tests_b |

1092: --| LeAta Jackson 08-Nov-2002 Karen said unvalidated tests |
1093: --| should not automatically be in spec. |
1094: --| |
1095: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
1096: --| in select for table - gmd_spec_tests_b |
1097: --| srakrish 18-Dec-2006 bug 5652689: Corrected the cursor |
1098: --| fetch position |
1099: --+========================================================================+
1100: -- End of comments

Line 1114: FROM gmd_qc_tests_b t, gmd_spec_tests_b st

1110:
1111: -- Cursors
1112: CURSOR c_spec_test_val (p_spec_id NUMBER, p_test_id NUMBER) IS
1113: SELECT t.test_type, st.min_value_num, st.max_value_num, st.target_value_char
1114: FROM gmd_qc_tests_b t, gmd_spec_tests_b st
1115: WHERE t.test_id= st.test_id
1116: AND st.exclude_ind IS NULL
1117: AND st.spec_id = p_spec_id
1118: AND st.test_id = p_test_id

Line 1308: --| in select for table - gmd_spec_tests_b |

1304: --| Chetan Nagar 05-Dec-2002 Assign the OUT variables at proper |
1305: --| index position. |
1306: --| |
1307: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
1308: --| in select for table - gmd_spec_tests_b |
1309: --| M.Grosser 04-May-2006: BUG 5167171 - Forward Port of BUG 5097450 |
1310: --| Modified code to prevent the setting of sample disposition |
1311: --| to In Progress on the addition of a test if the current |
1312: --| disposition is Pending |

Line 1567: FROM gmd_spec_tests_b st, gmd_test_methods_b tm

1563: IF (l_additional_test_ind IS NULL) THEN
1564: -- Test is part of the Spec so get the replicate from spec.
1565: SELECT st.test_replicate, st.viability_duration, tm.resources
1566: INTO l_replicate,l_viability_duration, l_resources
1567: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
1568: WHERE st.spec_id = l_event_spec_disp.spec_id
1569: AND st.exclude_ind IS NULL
1570: AND st.test_id = p_test_ids(i)
1571: AND st.test_method_id = tm.test_method_id

Line 2018: --| in select for table - gmd_spec_tests_b |

2014: --| HISTORY |
2015: --| Chetan Nagar 21-Aug-2002 Created. |
2016: --| |
2017: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
2018: --| in select for table - gmd_spec_tests_b |
2019: --| |
2020: --| RLNAGARA 07-Feb-2006 Modified the cursor c_vrs_vw and get_organization_code. |
2021: --| RLNAGARA 19-MAY-2006 Bug#5220513 (FP of 5026764)
2022: --| Added code so as to re-evaluate the results against the target |

Line 2051: FROM gmd_spec_tests_b st, gmd_test_methods_b tm

2047: CURSOR c_spec_tests (p_spec_id NUMBER) IS
2048: SELECT st.test_id
2049: , st.test_replicate
2050: , tm.test_kit_inv_item_id
2051: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
2052: WHERE st.spec_id = p_spec_id
2053: AND st.exclude_ind IS NULL
2054: AND st.test_method_id = tm.test_method_id
2055: ;

Line 2074: l_spec_id gmd_spec_tests_b.spec_id%TYPE;

2070: ;
2071:
2072: --Begin Bug#5220513
2073: l_test_id GMD_QC_TESTS.test_id%TYPE;
2074: l_spec_id gmd_spec_tests_b.spec_id%TYPE;
2075:
2076: CURSOR c_evaluation_ind (p_result_id NUMBER, p_event_spec_disp_id NUMBER) IS
2077: SELECT evaluation_ind from gmd_spec_results gsr, gmd_event_spec_disp esd --, gmd_sample_spec_disp ssd
2078: WHERE gsr.result_id=p_result_id

Line 2107: FROM gmd_spec_tests_b s

2103: LocalDisRec c_get_display%ROWTYPE;
2104:
2105: CURSOR c_get_spec_test_num IS
2106: SELECT s.min_value_num, s.max_value_num, s.target_value_num,s.display_precision
2107: FROM gmd_spec_tests_b s
2108: WHERE s.spec_id = l_spec_id
2109: AND s.test_id = l_test_id
2110: AND s.exclude_ind IS NULL;
2111:

Line 2116: FROM gmd_spec_tests_b s

2112: LocalNumRec c_get_spec_test_num%ROWTYPE;
2113:
2114: CURSOR c_get_spec_test_char IS
2115: SELECT s.min_value_char, s.max_value_char, s.target_value_char
2116: FROM gmd_spec_tests_b s
2117: WHERE s.spec_id = l_spec_id
2118: AND s.test_id = l_test_id
2119: AND s.exclude_ind IS NULL;
2120:

Line 2125: FROM gmd_spec_tests_b

2121: LocalCharRec c_get_spec_test_char%ROWTYPE;
2122:
2123: CURSOR c_spec_test_all (p_spec_id NUMBER, p_test_id NUMBER) IS
2124: SELECT *
2125: FROM gmd_spec_tests_b
2126: WHERE spec_id = p_spec_id
2127: AND test_id = p_test_id
2128: ;
2129:

Line 2134: l_spec_test_all GMD_SPEC_TESTS_B%ROWTYPE;

2130:
2131: -- Local Variables
2132: x_rec result_data;
2133: old_event_spec_disp_id NUMBER;
2134: l_spec_test_all GMD_SPEC_TESTS_B%ROWTYPE;
2135:
2136: --End Bug#5220513
2137:
2138: --RLNAGARA Bug 4918820 Changed from mtl_organizations to mtl_parameters

Line 2794: --| in select for table - gmd_spec_tests_b |

2790: --| Added display_precisions column to the select list
2791: --| in the cursor c_get_spec_test_num
2792: --| |
2793: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
2794: --| in select for table - gmd_spec_tests_b |
2795: --| Rameshwar 13-APR-2004 B#3545701 |
2796: --| Added non validated test type to retrieve |
2797: --| target values for non-validated tests. |
2798: --========================================================================+

Line 2850: FROM gmd_spec_tests_b s

2846: --BEGIN BUG#2871126 Rameshwar
2847: --Added display_precision to the selct list.
2848: CURSOR c_get_spec_test_num IS
2849: SELECT s.min_value_num, s.max_value_num, s.target_value_num,s.display_precision
2850: FROM gmd_spec_tests_b s
2851: WHERE s.spec_id = l_spec_id
2852: AND s.test_id = l_test_id
2853: AND s.exclude_ind IS NULL;
2854:

Line 2864: FROM gmd_spec_tests_b s

2860:
2861:
2862: CURSOR c_get_spec_test_char IS
2863: SELECT s.min_value_char, s.max_value_char, s.target_value_char
2864: FROM gmd_spec_tests_b s
2865: WHERE s.spec_id = l_spec_id
2866: AND s.test_id = l_test_id
2867: AND s.exclude_ind IS NULL;
2868:

Line 3729: --| in select for table - gmd_spec_tests_b |

3725: --| HISTORY |
3726: --| Chetan Nagar 04-Sep-2002 Created. |
3727: --| |
3728: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
3729: --| in select for table - gmd_spec_tests_b |
3730: --| |
3731: --| RLNAGARA 21-Jul-2006 B5396610 Modified the CURSOR c_test_date. |
3732: --+========================================================================+
3733: -- End of comments

Line 3771: FROM gmd_spec_tests_b

3767: ;
3768:
3769: CURSOR c_spec_test (p_spec_id NUMBER, p_test_id NUMBER) IS
3770: SELECT display_precision
3771: FROM gmd_spec_tests_b
3772: WHERE spec_id = p_spec_id
3773: AND test_id = p_test_id
3774: AND exclude_ind IS NULL
3775: ;

Line 4831: --| in select for table - gmd_spec_tests_b |

4827: --| Ger Kelly 17 Sep 2002 Created. |
4828: --| GK 17 Oct 2002 B 2621648 Changed the IF, ELSIF to IF END IF for the text chars
4829: --| |
4830: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
4831: --| in select for table - gmd_spec_tests_b |
4832: --+========================================================================+
4833: PROCEDURE get_composite_rslt
4834: (
4835: p_composite_spec_disp_id IN NUMBER,

Line 4885: FROM gmd_spec_tests_b s

4881: LocalTypeRec c_get_type%ROWTYPE;
4882:
4883: CURSOR c_get_spec_test_num IS
4884: SELECT s.min_value_num, s.max_value_num, s.target_value_num
4885: FROM gmd_spec_tests_b s
4886: WHERE s.spec_id = l_spec_id
4887: AND s.test_id = l_test_id
4888: AND s.exclude_ind IS NULL;
4889: LocalNumRec c_get_spec_test_num%ROWTYPE;

Line 4893: FROM gmd_spec_tests_b s

4889: LocalNumRec c_get_spec_test_num%ROWTYPE;
4890:
4891: CURSOR c_get_spec_test_char IS
4892: SELECT s.min_value_char, s.max_value_char, s.target_value_char
4893: FROM gmd_spec_tests_b s
4894: WHERE s.spec_id = l_spec_id
4895: AND s.test_id = l_test_id
4896: AND s.exclude_ind IS NULL;
4897: LocalCharRec c_get_spec_test_char%ROWTYPE;

Line 5744: --| in select for table - gmd_spec_tests_b |

5740: -- #
5741: -- # HISTORY
5742: --| |
5743: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
5744: --| in select for table - gmd_spec_tests_b |
5745: --| |
5746: --| Vipul Vaish 23-Jul-2003 Bug#3063671 |
5747: --| Added a call to the Validate_Result procedure which is used |
5748: --| to update the gmd_spec_results table with proper values when the |

Line 5810: FROM gmd_spec_tests_b

5806: --BEGIN BUG#3063671 Vipul Vaish
5807: --Declared a Cursor to fetch the test type
5808: CURSOR c_spec_test_all (p_spec_id NUMBER, p_test_id NUMBER) IS
5809: SELECT *
5810: FROM gmd_spec_tests_b
5811: WHERE spec_id = p_spec_id
5812: AND test_id = p_test_id
5813: ;
5814:

Line 5831: l_spec_test_all GMD_SPEC_TESTS_B%ROWTYPE;

5827:
5828: l_additional_test_ind VARCHAR2(1);
5829: l_min_value_num number;
5830: l_max_value_num number;
5831: l_spec_test_all GMD_SPEC_TESTS_B%ROWTYPE;
5832: --Declared the X_rec of result_data type.
5833: X_rec result_data;
5834: --END BUG#3063671
5835:

Line 5851: FROM gmd_spec_tests_b

5847: ;
5848:
5849: CURSOR c_spec_test (p_spec_id NUMBER, p_test_id NUMBER) IS
5850: SELECT display_precision, report_precision
5851: FROM gmd_spec_tests_b
5852: WHERE spec_id = p_spec_id
5853: AND test_id = p_test_id
5854: AND exclude_ind IS NULL
5855: ;

Line 6097: --| in select for table - gmd_spec_tests_b |

6093: --| Else Disposition Change not required.
6094: --|
6095: --| |
6096: --| Chetan Nagar 01-Apr-2002 Added exclude_ind column condition |
6097: --| in select for table - gmd_spec_tests_b |
6098: --| RLNAGARA 27-Mar-2006 B5106039 Modified the procedure so that it considers the Flag |
6099: --| Consider Optional Tests Result which is there in Process Quality Parameters Form |
6100: --+========================================================================+
6101:

Line 6569: gmd_spec_tests_b st

6565: -- Select COUNT of Tests with Evaluation other then ACCEPT
6566: SELECT count(1)
6567: INTO l_count_with_spec
6568: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,
6569: gmd_spec_tests_b st
6570: WHERE esd.event_spec_disp_id = l_sample_rec.event_spec_disp_id
6571: AND esd.event_spec_disp_id = sr.event_spec_disp_id
6572: AND sr.result_id = r.result_id
6573: AND r.sample_id = p_sample_id

Line 6658: gmd_spec_tests_b st

6654: -- Select COUNT of Tests with Evaluation other then ACCEPT
6655: SELECT count(1)
6656: INTO l_count_with_spec
6657: FROM gmd_event_spec_disp esd, gmd_results r, gmd_spec_results sr,
6658: gmd_spec_tests_b st
6659: WHERE esd.event_spec_disp_id = l_sample_rec.event_spec_disp_id
6660: AND esd.event_spec_disp_id = sr.event_spec_disp_id
6661: AND sr.result_id = r.result_id
6662: AND r.sample_id = p_sample_id

Line 7046: gmd_composite_results cr, gmd_spec_tests_b st

7042:
7043: SELECT count(1)
7044: INTO l_count_with_spec
7045: FROM gmd_composite_spec_disp csd, gmd_event_spec_disp esd,
7046: gmd_composite_results cr, gmd_spec_tests_b st
7047: WHERE csd.event_spec_disp_id = l_event_spec_disp_id
7048: AND csd.latest_ind = 'Y'
7049: AND csd.event_spec_disp_id = esd.event_spec_disp_id
7050: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id

Line 7070: FROM gmd_spec_tests_b st

7066: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id
7067: AND cr.in_spec_ind IS NULL -- Result is out-of-spec
7068: AND cr.test_id NOT IN
7069: (SELECT st.test_id
7070: FROM gmd_spec_tests_b st
7071: WHERE st.spec_id = esd.spec_id)
7072: ;
7073:
7074: l_count := l_count_with_spec + l_count_wo_spec;