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_COMPOSITE_RESULTS

Line 1069: FROM gmd_composite_results cr

1065: WHERE st.spec_id = p_spec_id
1066: AND st.exclude_ind IS NULL
1067: AND st.test_id NOT IN
1068: (SELECT cr.test_id
1069: FROM gmd_composite_results cr
1070: WHERE cr.composite_spec_disp_id = p_composite_spec_disp_id)
1071: ORDER BY st.seq
1072: ;
1073:

Line 3599: FROM gmd_composite_spec_disp csd, gmd_composite_results cr, gmd_composite_result_assoc cra

3595:
3596: -- Cursors
3597: CURSOR c_composite (p_event_spec_disp_id NUMBER, p_result_id NUMBER) IS
3598: SELECT 1
3599: FROM gmd_composite_spec_disp csd, gmd_composite_results cr, gmd_composite_result_assoc cra
3600: WHERE csd.event_spec_disp_id = p_event_spec_disp_id
3601: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id
3602: AND cr.composite_result_id = cra.composite_result_id
3603: AND cra.result_id = p_result_id

Line 3972: l_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;

3968: l_return_status VARCHAR2(1);
3969: sample_cnt PLS_INTEGER;
3970:
3971: l_composite_spec_disp GMD_COMPOSITE_SPEC_DISP%ROWTYPE;
3972: l_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;
3973: l_composite_result_assoc GMD_COMPOSITE_RESULT_ASSOC%ROWTYPE;
3974:
3975: l_out_composite_spec_disp GMD_COMPOSITE_SPEC_DISP%ROWTYPE;
3976: l_out_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;

Line 3976: l_out_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;

3972: l_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;
3973: l_composite_result_assoc GMD_COMPOSITE_RESULT_ASSOC%ROWTYPE;
3974:
3975: l_out_composite_spec_disp GMD_COMPOSITE_SPEC_DISP%ROWTYPE;
3976: l_out_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;
3977:
3978: -- Exceptions
3979: e_comp_spec_disp_insert_error EXCEPTION;
3980: e_comp_result_insert_error EXCEPTION;

Line 4180: -- a new record in GMD_COMPOSITE_RESULTS

4176: gmd_debug.put_line(' l_standard_deviation - '|| l_standard_deviation);
4177: END IF;
4178:
4179: -- Now, we have all the composite values for the test so create
4180: -- a new record in GMD_COMPOSITE_RESULTS
4181:
4182: -- Construct the record
4183: l_composite_result.COMPOSITE_SPEC_DISP_ID := l_composite_spec_disp.composite_spec_disp_id;
4184: l_composite_result.TEST_ID := test_rec.test_id;

Line 4214: -- We are ready for insert in GMD_COMPOSITE_RESULTS, so then lets do it.

4210: l_composite_result.CREATION_DATE := l_date;
4211: l_composite_result.CREATED_BY := l_user_id;
4212: l_composite_result.LAST_UPDATE_DATE := l_date;
4213: l_composite_result.LAST_UPDATED_BY := l_user_id;
4214: -- We are ready for insert in GMD_COMPOSITE_RESULTS, so then lets do it.
4215: IF NOT(GMD_COMPOSITE_RESULTS_PVT.Insert_Row(
4216: p_composite_results => l_composite_result,
4217: x_composite_results => l_out_composite_result)
4218: )

Line 4215: IF NOT(GMD_COMPOSITE_RESULTS_PVT.Insert_Row(

4211: l_composite_result.CREATED_BY := l_user_id;
4212: l_composite_result.LAST_UPDATE_DATE := l_date;
4213: l_composite_result.LAST_UPDATED_BY := l_user_id;
4214: -- We are ready for insert in GMD_COMPOSITE_RESULTS, so then lets do it.
4215: IF NOT(GMD_COMPOSITE_RESULTS_PVT.Insert_Row(
4216: p_composite_results => l_composite_result,
4217: x_composite_results => l_out_composite_result)
4218: )
4219: THEN

Line 4226: gmd_debug.put_line(' Record created in GMD_COMPOSITE_RESULTS. CR ID - ' || l_composite_result.composite_result_id);

4222: END IF;
4223: l_composite_result.COMPOSITE_RESULT_ID := l_out_composite_result.COMPOSITE_RESULT_ID;
4224:
4225: IF (l_debug = 'Y') THEN
4226: gmd_debug.put_line(' Record created in GMD_COMPOSITE_RESULTS. CR ID - ' || l_composite_result.composite_result_id);
4227: END IF;
4228:
4229: sample_cnt := 0;
4230:

Line 4266: UPDATE gmd_composite_results

4262:
4263: END LOOP; -- All atomic results for the test
4264:
4265: -- Now update the Sample Total And Sample Count Used fields
4266: UPDATE gmd_composite_results
4267: SET sample_total = sample_cnt,
4268: sample_cnt_used = sample_cnt
4269: WHERE composite_result_id = l_composite_result.composite_result_id
4270: AND test_id = test_rec.test_id

Line 5041: FROM gmd_composite_results cr

5037: cr.median_num,
5038: cr.median_char,
5039: cr.mode_num,
5040: cr.mode_char
5041: FROM gmd_composite_results cr
5042: WHERE cr.composite_spec_disp_id = p_composite_spec_disp_id;
5043: LocalComResRec c_get_composite_results%ROWTYPE;
5044:
5045: CURSOR c_get_type IS

Line 7412: -- gmd_composite_results cr

7408: -- REPLACED FOLLOWING WITH
7409: -- SELECT count(1)
7410: -- INTO l_count
7411: -- FROM gmd_composite_spec_disp csd,
7412: -- gmd_composite_results cr
7413: -- WHERE csd.event_spec_disp_id = l_event_spec_disp_id
7414: -- AND csd.latest_ind = 'Y'
7415: -- AND csd.composite_spec_disp_id = cr.composite_spec_disp_id
7416: -- AND cr.in_spec_ind IS NULL -- Result is out-of-spec

Line 7423: gmd_composite_results cr, gmd_spec_tests_b st

7419:
7420: SELECT count(1)
7421: INTO l_count_with_spec
7422: FROM gmd_composite_spec_disp csd, gmd_event_spec_disp esd,
7423: gmd_composite_results cr, gmd_spec_tests_b st
7424: WHERE csd.event_spec_disp_id = l_event_spec_disp_id
7425: AND csd.latest_ind = 'Y'
7426: AND csd.event_spec_disp_id = esd.event_spec_disp_id
7427: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id

Line 7439: gmd_composite_results cr

7435:
7436: SELECT count(1)
7437: INTO l_count_wo_spec
7438: FROM gmd_composite_spec_disp csd, gmd_event_spec_disp esd,
7439: gmd_composite_results cr
7440: WHERE csd.event_spec_disp_id = l_event_spec_disp_id
7441: AND csd.latest_ind = 'Y'
7442: AND csd.event_spec_disp_id = esd.event_spec_disp_id
7443: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id