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 2998: FROM gmd_result_data_points_gt;

2994: /* Cursors */
2995:
2996: CURSOR c_res IS
2997: SELECT *
2998: FROM gmd_result_data_points_gt;
2999:
3000: CURSOR c_get_type IS
3001: SELECT t.test_type, t.test_code, t.test_method_id, t.expression, t.test_unit,
3002: m.test_method_code

Line 3797: EXECUTE IMMEDIATE 'delete from gmd_result_data_points_gt';

3793: x_return_status := FND_API.G_RET_STS_SUCCESS;
3794: l_start_date := GMA_CORE_PKG.get_date_constant_d('SY$MIN_DATE');
3795: -- Bug #2626977 (JKB) Removed reference to date profile above.
3796:
3797: EXECUTE IMMEDIATE 'delete from gmd_result_data_points_gt';
3798: l_sql_stmt :=
3799: 'INSERT INTO gmd_result_data_points_gt (result_id, test_id, exclude_ind, data_num, data_char)'
3800: ||' ('
3801: ||' SELECT result_id, test_id, 0, result_value_num, result_value_char FROM'

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

3795: -- Bug #2626977 (JKB) Removed reference to date profile above.
3796:
3797: EXECUTE IMMEDIATE 'delete from gmd_result_data_points_gt';
3798: l_sql_stmt :=
3799: 'INSERT INTO gmd_result_data_points_gt (result_id, test_id, exclude_ind, data_num, data_char)'
3800: ||' ('
3801: ||' SELECT result_id, test_id, 0, result_value_num, result_value_char FROM'
3802: ||' ('
3803: ||' SELECT r.result_id, r.test_id, r.result_value_num, r.result_value_char,'

Line 3862: FROM gmd_result_data_points_gt

3858:
3859: PROCEDURE dump_data_points IS
3860: CURSOR c1 IS
3861: SELECT *
3862: FROM gmd_result_data_points_gt
3863: ORDER BY TEST_ID;
3864: BEGIN
3865: IF (l_debug = 'Y') THEN
3866: gmd_debug.put_line('Data in session table - gmd_result_data_points_gt');

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

3862: FROM gmd_result_data_points_gt
3863: ORDER BY TEST_ID;
3864: BEGIN
3865: IF (l_debug = 'Y') THEN
3866: gmd_debug.put_line('Data in session table - gmd_result_data_points_gt');
3867: gmd_debug.put_line('Result ID Test ID Data Num Data Char Exclude Ind');
3868: END IF;
3869:
3870: FOR c_rec IN c1

Line 3914: FROM gmd_result_data_points_gt gt, gmd_results r

3910: -- Curosrs
3911: -- RLNAGARA B5396610 Modified below cursor to select tests in order of seq .
3912: CURSOR c_test_data IS
3913: SELECT gt.test_id
3914: FROM gmd_result_data_points_gt gt, gmd_results r
3915: WHERE gt.result_id = r.result_id
3916: GROUP BY gt.test_id
3917: ORDER BY min(r.seq)
3918: ;

Line 3922: FROM gmd_result_data_points_gt

3918: ;
3919:
3920: CURSOR c_all_test_data (p_test_id NUMBER) IS
3921: SELECT result_id, data_num, data_char
3922: FROM gmd_result_data_points_gt
3923: WHERE test_id = p_test_id
3924: ;
3925:
3926: CURSOR c_spec_id (p_event_spec_disp_id NUMBER) IS

Line 4331: FROM gmd_result_data_points_gt

4327: ;
4328:
4329: CURSOR c_mean(p_test_id NUMBER) IS
4330: SELECT avg(data_num)
4331: FROM gmd_result_data_points_gt
4332: WHERE test_id = p_test_id
4333: AND exclude_ind = 0
4334: AND data_num IS NOT NULL
4335: ;

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

4382: --+========================================================================+
4383: --| API Name : qc_median |
4384: --| TYPE : Group |
4385: --| Notes : This function returns median for the data points in |
4386: --| gmd_result_data_points_gt table for a give test_id. |
4387: --| |
4388: --| If the data points are as below: |
4389: --| 5, 11, 14, 16, 20 |
4390: --| |

Line 4435: FROM gmd_result_data_points_gt

4431: SELECT data_num
4432: FROM
4433: (
4434: SELECT data_num
4435: FROM gmd_result_data_points_gt
4436: WHERE test_id = p_test_id
4437: AND exclude_ind = 0
4438: AND data_num IS NOT NULL
4439: ORDER BY data_num

Line 4442: FROM gmd_result_data_points_gt

4438: AND data_num IS NOT NULL
4439: ORDER BY data_num
4440: )
4441: WHERE rownum <= (SELECT ceil(count(*)/2)
4442: FROM gmd_result_data_points_gt
4443: WHERE test_id = p_test_id
4444: AND exclude_ind = 0
4445: AND data_num IS NOT NULL)
4446: )

Line 4455: FROM gmd_result_data_points_gt

4451: SELECT data_num
4452: FROM
4453: (
4454: SELECT data_num
4455: FROM gmd_result_data_points_gt
4456: WHERE test_id = p_test_id
4457: AND exclude_ind = 0
4458: AND data_num IS NOT NULL
4459: ORDER BY data_num desc

Line 4462: FROM gmd_result_data_points_gt

4458: AND data_num IS NOT NULL
4459: ORDER BY data_num desc
4460: )
4461: WHERE rownum <= (SELECT ceil(count(*)/2)
4462: FROM gmd_result_data_points_gt
4463: WHERE test_id = p_test_id
4464: AND exclude_ind = 0
4465: AND data_num IS NOT NULL)
4466: )

Line 4501: FROM gmd_result_data_points_gt

4497:
4498: -- Get the count of data points.
4499: SELECT nvl(count(*), 0)
4500: INTO l_count
4501: FROM gmd_result_data_points_gt
4502: WHERE test_id = p_test_id
4503: AND exclude_ind = 0
4504: AND data_num IS NOT NULL
4505: ;

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

4563: --+========================================================================+
4564: --| API Name : qc_mode |
4565: --| TYPE : Group |
4566: --| Notes : This function returns mode for the data points in |
4567: --| gmd_result_data_points_gt table for a give test_id. |
4568: --| |
4569: --| HISTORY |
4570: --| Chetan Nagar 04-Sep-2002 Created. |
4571: --| |

Line 4587: FROM gmd_result_data_points_gt

4583:
4584: -- Curosrs
4585: CURSOR c_mode_num(p_test_id NUMBER) IS
4586: SELECT data_num
4587: FROM gmd_result_data_points_gt
4588: WHERE test_id = p_test_id
4589: AND exclude_ind = 0
4590: AND data_num IS NOT NULL
4591: GROUP BY data_num

Line 4593: FROM gmd_result_data_points_gt

4589: AND exclude_ind = 0
4590: AND data_num IS NOT NULL
4591: GROUP BY data_num
4592: HAVING count(*) = (SELECT max(count(*))
4593: FROM gmd_result_data_points_gt
4594: WHERE test_id = p_test_id
4595: AND exclude_ind = 0
4596: AND data_num IS NOT NULL
4597: GROUP BY data_num)

Line 4602: FROM gmd_result_data_points_gt

4598: ;
4599:
4600: CURSOR c_mode_char(p_test_id NUMBER) IS
4601: SELECT data_char
4602: FROM gmd_result_data_points_gt
4603: WHERE test_id = p_test_id
4604: AND exclude_ind = 0
4605: AND data_char IS NOT NULL
4606: GROUP BY data_char

Line 4608: FROM gmd_result_data_points_gt

4604: AND exclude_ind = 0
4605: AND data_char IS NOT NULL
4606: GROUP BY data_char
4607: HAVING count(*) = (SELECT max(count(*))
4608: FROM gmd_result_data_points_gt
4609: WHERE test_id = p_test_id
4610: AND exclude_ind = 0
4611: AND data_char IS NOT NULL
4612: GROUP BY data_char)

Line 4745: FROM gmd_result_data_points_gt

4741:
4742: -- Curosrs
4743: CURSOR c_high_num(p_test_id NUMBER) IS
4744: SELECT max(data_num)
4745: FROM gmd_result_data_points_gt
4746: WHERE test_id = p_test_id
4747: AND exclude_ind = 0
4748: AND data_num IS NOT NULL
4749: ;

Line 4840: FROM gmd_result_data_points_gt

4836:
4837: -- Curosrs
4838: CURSOR c_low_num(p_test_id NUMBER) IS
4839: SELECT min(data_num)
4840: FROM gmd_result_data_points_gt
4841: WHERE test_id = p_test_id
4842: AND exclude_ind = 0
4843: AND data_num IS NOT NULL
4844: ;

Line 4936: FROM gmd_result_data_points_gt

4932: ;
4933:
4934: CURSOR c_stddev(p_test_id NUMBER) IS
4935: SELECT stddev(data_num)
4936: FROM gmd_result_data_points_gt
4937: WHERE test_id = p_test_id
4938: AND exclude_ind = 0
4939: AND data_num IS NOT NULL
4940: ;

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

5928: --| nvl SQL function. |
5929: --| |
5930: --| Ravi Boddu 29-APR-2004 Bug 3447472 Test Groups Enhancement |
5931: --| Modifed cursors c_exp_test and c_all_ref_test to the data from base |
5932: --| tables, rather than the Global Temp table gmd_result_data_points_gt |
5933: --| which fetches only the most recent Test Replicates. Also not calling |
5934: --| populate_result_data_points anymore
5935: --| RLNAGARA 16-MAR-2006 Bug#5076736. Updating the result date of |
5936: --| results properly depending on the result value. |

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

5980: where test_id = p_exp_test_id;
5981:
5982: -- Modified the following cursor to fetch all the test replicates
5983: -- whichever is not calculated the Result yet.
5984: -- Earlier the data was being fetched from Global Temp Table gmd_result_data_points_gt
5985: -- Test Groups Enh Bug# 3447472
5986: CURSOR c_exp_test IS
5987: SELECT t.test_id, t.test_code, t.expression, t.display_precision,
5988: t.report_precision, r.result_id, r.result_value_num , r.test_replicate_cnt -- 14021970 added r.test_replicate_cnt

Line 6042: FROM gmd_result_data_points_gt gtmp,

6038:
6039: CURSOR c_all_ref_test (p_exp_test_id NUMBER) IS
6040: SELECT gtmp.data_num,
6041: t.test_code
6042: FROM gmd_result_data_points_gt gtmp,
6043: gmd_results r,
6044: gmd_qc_tests_b t,
6045: gmd_qc_test_values_b tv
6046: WHERE gtmp.result_id = r.result_id

Line 7668: EXECUTE IMMEDIATE 'delete from gmd_result_data_points_gt';

7664: x_return_status := FND_API.G_RET_STS_SUCCESS;
7665: l_start_date := GMA_CORE_PKG.get_date_constant_d('SY$MIN_DATE');
7666: -- Bug #2626977 (JKB) Removed reference to date profile above.
7667:
7668: EXECUTE IMMEDIATE 'delete from gmd_result_data_points_gt';
7669: l_sql_stmt :=
7670: 'INSERT INTO gmd_result_data_points_gt (result_id, test_id, exclude_ind, data_num, data_char)'
7671: ||' ('
7672: ||' SELECT result_id, test_id, 0, result_value_num, result_value_char FROM'

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

7666: -- Bug #2626977 (JKB) Removed reference to date profile above.
7667:
7668: EXECUTE IMMEDIATE 'delete from gmd_result_data_points_gt';
7669: l_sql_stmt :=
7670: 'INSERT INTO gmd_result_data_points_gt (result_id, test_id, exclude_ind, data_num, data_char)'
7671: ||' ('
7672: ||' SELECT result_id, test_id, 0, result_value_num, result_value_char FROM'
7673: ||' ('
7674: ||' SELECT r.result_id, r.test_id, r.result_value_num, r.result_value_char,'