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_RESULT_DATA_POINTS_GT

Line 2830: FROM gmd_result_data_points_gt;

2826: /* Cursors */
2827:
2828: CURSOR c_res IS
2829: SELECT *
2830: FROM gmd_result_data_points_gt;
2831:
2832: CURSOR c_get_type IS
2833: SELECT t.test_type, t.test_code, t.test_method_id, t.expression, t.test_unit,
2834: m.test_method_code

Line 3628: EXECUTE IMMEDIATE 'delete from gmd_result_data_points_gt';

3624: x_return_status := FND_API.G_RET_STS_SUCCESS;
3625: l_start_date := GMA_CORE_PKG.get_date_constant_d('SY$MIN_DATE');
3626: -- Bug #2626977 (JKB) Removed reference to date profile above.
3627:
3628: EXECUTE IMMEDIATE 'delete from gmd_result_data_points_gt';
3629: l_sql_stmt :=
3630: 'INSERT INTO gmd_result_data_points_gt (result_id, test_id, exclude_ind, data_num, data_char)'
3631: ||' ('
3632: ||' SELECT result_id, test_id, 0, result_value_num, result_value_char FROM'

Line 3630: 'INSERT INTO gmd_result_data_points_gt (result_id, test_id, exclude_ind, data_num, data_char)'

3626: -- Bug #2626977 (JKB) Removed reference to date profile above.
3627:
3628: EXECUTE IMMEDIATE 'delete from gmd_result_data_points_gt';
3629: l_sql_stmt :=
3630: 'INSERT INTO gmd_result_data_points_gt (result_id, test_id, exclude_ind, data_num, data_char)'
3631: ||' ('
3632: ||' SELECT result_id, test_id, 0, result_value_num, result_value_char FROM'
3633: ||' ('
3634: ||' SELECT r.result_id, r.test_id, r.result_value_num, r.result_value_char,'

Line 3693: FROM gmd_result_data_points_gt

3689:
3690: PROCEDURE dump_data_points IS
3691: CURSOR c1 IS
3692: SELECT *
3693: FROM gmd_result_data_points_gt
3694: ORDER BY TEST_ID;
3695: BEGIN
3696: IF (l_debug = 'Y') THEN
3697: gmd_debug.put_line('Data in session table - gmd_result_data_points_gt');

Line 3697: gmd_debug.put_line('Data in session table - gmd_result_data_points_gt');

3693: FROM gmd_result_data_points_gt
3694: ORDER BY TEST_ID;
3695: BEGIN
3696: IF (l_debug = 'Y') THEN
3697: gmd_debug.put_line('Data in session table - gmd_result_data_points_gt');
3698: gmd_debug.put_line('Result ID Test ID Data Num Data Char Exclude Ind');
3699: END IF;
3700:
3701: FOR c_rec IN c1

Line 3745: FROM gmd_result_data_points_gt gt, gmd_results r

3741: -- Curosrs
3742: -- RLNAGARA B5396610 Modified below cursor to select tests in order of seq .
3743: CURSOR c_test_data IS
3744: SELECT gt.test_id
3745: FROM gmd_result_data_points_gt gt, gmd_results r
3746: WHERE gt.result_id = r.result_id
3747: GROUP BY gt.test_id
3748: ORDER BY min(r.seq)
3749: ;

Line 3753: FROM gmd_result_data_points_gt

3749: ;
3750:
3751: CURSOR c_all_test_data (p_test_id NUMBER) IS
3752: SELECT result_id, data_num, data_char
3753: FROM gmd_result_data_points_gt
3754: WHERE test_id = p_test_id
3755: ;
3756:
3757: CURSOR c_spec_id (p_event_spec_disp_id NUMBER) IS

Line 4162: FROM gmd_result_data_points_gt

4158: ;
4159:
4160: CURSOR c_mean(p_test_id NUMBER) IS
4161: SELECT avg(data_num)
4162: FROM gmd_result_data_points_gt
4163: WHERE test_id = p_test_id
4164: AND exclude_ind = 0
4165: AND data_num IS NOT NULL
4166: ;

Line 4217: --| gmd_result_data_points_gt table for a give test_id. |

4213: --+========================================================================+
4214: --| API Name : qc_median |
4215: --| TYPE : Group |
4216: --| Notes : This function returns median for the data points in |
4217: --| gmd_result_data_points_gt table for a give test_id. |
4218: --| |
4219: --| If the data points are as below: |
4220: --| 5, 11, 14, 16, 20 |
4221: --| |

Line 4266: FROM gmd_result_data_points_gt

4262: SELECT data_num
4263: FROM
4264: (
4265: SELECT data_num
4266: FROM gmd_result_data_points_gt
4267: WHERE test_id = p_test_id
4268: AND exclude_ind = 0
4269: AND data_num IS NOT NULL
4270: ORDER BY data_num

Line 4273: FROM gmd_result_data_points_gt

4269: AND data_num IS NOT NULL
4270: ORDER BY data_num
4271: )
4272: WHERE rownum <= (SELECT ceil(count(*)/2)
4273: FROM gmd_result_data_points_gt
4274: WHERE test_id = p_test_id
4275: AND exclude_ind = 0
4276: AND data_num IS NOT NULL)
4277: )

Line 4286: FROM gmd_result_data_points_gt

4282: SELECT data_num
4283: FROM
4284: (
4285: SELECT data_num
4286: FROM gmd_result_data_points_gt
4287: WHERE test_id = p_test_id
4288: AND exclude_ind = 0
4289: AND data_num IS NOT NULL
4290: ORDER BY data_num desc

Line 4293: FROM gmd_result_data_points_gt

4289: AND data_num IS NOT NULL
4290: ORDER BY data_num desc
4291: )
4292: WHERE rownum <= (SELECT ceil(count(*)/2)
4293: FROM gmd_result_data_points_gt
4294: WHERE test_id = p_test_id
4295: AND exclude_ind = 0
4296: AND data_num IS NOT NULL)
4297: )

Line 4332: FROM gmd_result_data_points_gt

4328:
4329: -- Get the count of data points.
4330: SELECT nvl(count(*), 0)
4331: INTO l_count
4332: FROM gmd_result_data_points_gt
4333: WHERE test_id = p_test_id
4334: AND exclude_ind = 0
4335: AND data_num IS NOT NULL
4336: ;

Line 4398: --| gmd_result_data_points_gt table for a give test_id. |

4394: --+========================================================================+
4395: --| API Name : qc_mode |
4396: --| TYPE : Group |
4397: --| Notes : This function returns mode for the data points in |
4398: --| gmd_result_data_points_gt table for a give test_id. |
4399: --| |
4400: --| HISTORY |
4401: --| Chetan Nagar 04-Sep-2002 Created. |
4402: --| |

Line 4418: FROM gmd_result_data_points_gt

4414:
4415: -- Curosrs
4416: CURSOR c_mode_num(p_test_id NUMBER) IS
4417: SELECT data_num
4418: FROM gmd_result_data_points_gt
4419: WHERE test_id = p_test_id
4420: AND exclude_ind = 0
4421: AND data_num IS NOT NULL
4422: GROUP BY data_num

Line 4424: FROM gmd_result_data_points_gt

4420: AND exclude_ind = 0
4421: AND data_num IS NOT NULL
4422: GROUP BY data_num
4423: HAVING count(*) = (SELECT max(count(*))
4424: FROM gmd_result_data_points_gt
4425: WHERE test_id = p_test_id
4426: AND exclude_ind = 0
4427: AND data_num IS NOT NULL
4428: GROUP BY data_num)

Line 4433: FROM gmd_result_data_points_gt

4429: ;
4430:
4431: CURSOR c_mode_char(p_test_id NUMBER) IS
4432: SELECT data_char
4433: FROM gmd_result_data_points_gt
4434: WHERE test_id = p_test_id
4435: AND exclude_ind = 0
4436: AND data_char IS NOT NULL
4437: GROUP BY data_char

Line 4439: FROM gmd_result_data_points_gt

4435: AND exclude_ind = 0
4436: AND data_char IS NOT NULL
4437: GROUP BY data_char
4438: HAVING count(*) = (SELECT max(count(*))
4439: FROM gmd_result_data_points_gt
4440: WHERE test_id = p_test_id
4441: AND exclude_ind = 0
4442: AND data_char IS NOT NULL
4443: GROUP BY data_char)

Line 4576: FROM gmd_result_data_points_gt

4572:
4573: -- Curosrs
4574: CURSOR c_high_num(p_test_id NUMBER) IS
4575: SELECT max(data_num)
4576: FROM gmd_result_data_points_gt
4577: WHERE test_id = p_test_id
4578: AND exclude_ind = 0
4579: AND data_num IS NOT NULL
4580: ;

Line 4671: FROM gmd_result_data_points_gt

4667:
4668: -- Curosrs
4669: CURSOR c_low_num(p_test_id NUMBER) IS
4670: SELECT min(data_num)
4671: FROM gmd_result_data_points_gt
4672: WHERE test_id = p_test_id
4673: AND exclude_ind = 0
4674: AND data_num IS NOT NULL
4675: ;

Line 4767: FROM gmd_result_data_points_gt

4763: ;
4764:
4765: CURSOR c_stddev(p_test_id NUMBER) IS
4766: SELECT stddev(data_num)
4767: FROM gmd_result_data_points_gt
4768: WHERE test_id = p_test_id
4769: AND exclude_ind = 0
4770: AND data_num IS NOT NULL
4771: ;

Line 5757: --| tables, rather than the Global Temp table gmd_result_data_points_gt |

5753: --| nvl SQL function. |
5754: --| |
5755: --| Ravi Boddu 29-APR-2004 Bug 3447472 Test Groups Enhancement |
5756: --| Modifed cursors c_exp_test and c_all_ref_test to the data from base |
5757: --| tables, rather than the Global Temp table gmd_result_data_points_gt |
5758: --| which fetches only the most recent Test Replicates. Also not calling |
5759: --| populate_result_data_points anymore
5760: --| RLNAGARA 16-MAR-2006 Bug#5076736. Updating the result date of |
5761: --| results properly depending on the result value. |

Line 5784: -- Earlier the data was being fetched from Global Temp Table gmd_result_data_points_gt

5780: where test_id = p_exp_test_id;
5781:
5782: -- Modified the following cursor to fetch all the test replicates
5783: -- whichever is not calculated the Result yet.
5784: -- Earlier the data was being fetched from Global Temp Table gmd_result_data_points_gt
5785: -- Test Groups Enh Bug# 3447472
5786: CURSOR c_exp_test IS
5787: SELECT t.test_id, t.test_code, t.expression, t.display_precision,
5788: t.report_precision, r.result_id, r.result_value_num

Line 5839: FROM gmd_result_data_points_gt gtmp,

5835:
5836: CURSOR c_all_ref_test (p_exp_test_id NUMBER) IS
5837: SELECT gtmp.data_num,
5838: t.test_code
5839: FROM gmd_result_data_points_gt gtmp,
5840: gmd_results r,
5841: gmd_qc_tests_b t,
5842: gmd_qc_test_values_b tv
5843: WHERE gtmp.result_id = r.result_id