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 1016: FROM gmd_composite_results cr

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
1016: FROM gmd_composite_results cr
1017: WHERE cr.composite_spec_disp_id = p_composite_spec_disp_id)
1018: ORDER BY st.seq
1019: ;
1020:

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

3426:
3427: -- Cursors
3428: CURSOR c_composite (p_event_spec_disp_id NUMBER, p_result_id NUMBER) IS
3429: SELECT 1
3430: FROM gmd_composite_spec_disp csd, gmd_composite_results cr, gmd_composite_result_assoc cra
3431: WHERE csd.event_spec_disp_id = p_event_spec_disp_id
3432: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id
3433: AND cr.composite_result_id = cra.composite_result_id
3434: AND cra.result_id = p_result_id

Line 3803: l_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;

3799: l_return_status VARCHAR2(1);
3800: sample_cnt PLS_INTEGER;
3801:
3802: l_composite_spec_disp GMD_COMPOSITE_SPEC_DISP%ROWTYPE;
3803: l_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;
3804: l_composite_result_assoc GMD_COMPOSITE_RESULT_ASSOC%ROWTYPE;
3805:
3806: l_out_composite_spec_disp GMD_COMPOSITE_SPEC_DISP%ROWTYPE;
3807: l_out_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;

Line 3807: l_out_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;

3803: l_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;
3804: l_composite_result_assoc GMD_COMPOSITE_RESULT_ASSOC%ROWTYPE;
3805:
3806: l_out_composite_spec_disp GMD_COMPOSITE_SPEC_DISP%ROWTYPE;
3807: l_out_composite_result GMD_COMPOSITE_RESULTS%ROWTYPE;
3808:
3809: -- Exceptions
3810: e_comp_spec_disp_insert_error EXCEPTION;
3811: e_comp_result_insert_error EXCEPTION;

Line 4011: -- a new record in GMD_COMPOSITE_RESULTS

4007: gmd_debug.put_line(' l_standard_deviation - '|| l_standard_deviation);
4008: END IF;
4009:
4010: -- Now, we have all the composite values for the test so create
4011: -- a new record in GMD_COMPOSITE_RESULTS
4012:
4013: -- Construct the record
4014: l_composite_result.COMPOSITE_SPEC_DISP_ID := l_composite_spec_disp.composite_spec_disp_id;
4015: l_composite_result.TEST_ID := test_rec.test_id;

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

4041: l_composite_result.CREATION_DATE := l_date;
4042: l_composite_result.CREATED_BY := l_user_id;
4043: l_composite_result.LAST_UPDATE_DATE := l_date;
4044: l_composite_result.LAST_UPDATED_BY := l_user_id;
4045: -- We are ready for insert in GMD_COMPOSITE_RESULTS, so then lets do it.
4046: IF NOT(GMD_COMPOSITE_RESULTS_PVT.Insert_Row(
4047: p_composite_results => l_composite_result,
4048: x_composite_results => l_out_composite_result)
4049: )

Line 4046: IF NOT(GMD_COMPOSITE_RESULTS_PVT.Insert_Row(

4042: l_composite_result.CREATED_BY := l_user_id;
4043: l_composite_result.LAST_UPDATE_DATE := l_date;
4044: l_composite_result.LAST_UPDATED_BY := l_user_id;
4045: -- We are ready for insert in GMD_COMPOSITE_RESULTS, so then lets do it.
4046: IF NOT(GMD_COMPOSITE_RESULTS_PVT.Insert_Row(
4047: p_composite_results => l_composite_result,
4048: x_composite_results => l_out_composite_result)
4049: )
4050: THEN

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

4053: END IF;
4054: l_composite_result.COMPOSITE_RESULT_ID := l_out_composite_result.COMPOSITE_RESULT_ID;
4055:
4056: IF (l_debug = 'Y') THEN
4057: gmd_debug.put_line(' Record created in GMD_COMPOSITE_RESULTS. CR ID - ' || l_composite_result.composite_result_id);
4058: END IF;
4059:
4060: sample_cnt := 0;
4061:

Line 4097: UPDATE gmd_composite_results

4093:
4094: END LOOP; -- All atomic results for the test
4095:
4096: -- Now update the Sample Total And Sample Count Used fields
4097: UPDATE gmd_composite_results
4098: SET sample_total = sample_cnt,
4099: sample_cnt_used = sample_cnt
4100: WHERE composite_result_id = l_composite_result.composite_result_id
4101: AND test_id = test_rec.test_id

Line 4872: FROM gmd_composite_results cr

4868: cr.median_num,
4869: cr.median_char,
4870: cr.mode_num,
4871: cr.mode_char
4872: FROM gmd_composite_results cr
4873: WHERE cr.composite_spec_disp_id = p_composite_spec_disp_id;
4874: LocalComResRec c_get_composite_results%ROWTYPE;
4875:
4876: CURSOR c_get_type IS

Line 7035: -- gmd_composite_results cr

7031: -- REPLACED FOLLOWING WITH
7032: -- SELECT count(1)
7033: -- INTO l_count
7034: -- FROM gmd_composite_spec_disp csd,
7035: -- gmd_composite_results cr
7036: -- WHERE csd.event_spec_disp_id = l_event_spec_disp_id
7037: -- AND csd.latest_ind = 'Y'
7038: -- AND csd.composite_spec_disp_id = cr.composite_spec_disp_id
7039: -- AND cr.in_spec_ind IS NULL -- Result is out-of-spec

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 7062: gmd_composite_results cr

7058:
7059: SELECT count(1)
7060: INTO l_count_wo_spec
7061: FROM gmd_composite_spec_disp csd, gmd_event_spec_disp esd,
7062: gmd_composite_results cr
7063: WHERE csd.event_spec_disp_id = l_event_spec_disp_id
7064: AND csd.latest_ind = 'Y'
7065: AND csd.event_spec_disp_id = esd.event_spec_disp_id
7066: AND csd.composite_spec_disp_id = cr.composite_spec_disp_id