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_RESULT_TRANSFER_GRP dependencies on GMD_COMPOSITE_RESULTS

Line 123: from gmd_composite_results r,

119: r.range,
120: r.non_validated_result,
121: r.standard_deviation , ges.spec_id,
122: r.creation_date
123: from gmd_composite_results r,
124: gmd_composite_spec_disp sd,
125: gmd_event_spec_disp ges
126: where r.composite_spec_disp_id =sd.composite_spec_disp_id
127: --and sd.event_spec_disp_id = 1

Line 133: from gmd_composite_results r1,

129: and nvl(ges.spec_used_for_lot_attrib_ind,'N') = 'Y'
130: and nvl(sd.latest_ind,'N') = 'Y'
131: and ges.sampling_event_id = p_parent_id
132: and r.test_id in (select r1.test_id
133: from gmd_composite_results r1,
134: gmd_composite_spec_disp gcs,
135: gmd_event_spec_disp ges
136: where ges.event_spec_disp_id = gcs.event_spec_disp_id
137: and gcs.latest_ind = 'Y'

Line 145: from gmd_composite_results r1,

141:
142: Cursor c_get_child_composite(p_sampling_event_id IN NUMBER,
143: p_test_id IN NUMBER) IS
144: select r1.composite_result_id
145: from gmd_composite_results r1,
146: gmd_composite_spec_disp gcs,
147: gmd_event_spec_disp ges
148: where ges.event_spec_disp_id = gcs.event_spec_disp_id
149: and gcs.latest_ind = 'Y'

Line 454: FROM gmd_composite_results r,

450: r.ATTRIBUTE27,
451: r.ATTRIBUTE28,
452: r.ATTRIBUTE29,
453: r.ATTRIBUTE30
454: FROM gmd_composite_results r,
455: GMD_RESULT_TRANSFER_GT A
456: WHERE r.composite_result_id = a.parent_result_id;
457:
458:

Line 872: --rboddu Modified the following update statement to update gmd_composite_results with median_num, median_char selected from c_temp_table_cmpt. bug 3571258

868: to_char(c_temp_table_cmpt_row.mean),
869: c_temp_table_cmpt_row.mode_char);
870: l_place := 55;
871:
872: --rboddu Modified the following update statement to update gmd_composite_results with median_num, median_char selected from c_temp_table_cmpt. bug 3571258
873: UPDATE gmd_composite_results
874: SET in_spec_ind = l_in_spec,
875: mean= c_temp_table_cmpt_row.mean ,
876: mode_num= c_temp_table_cmpt_row.mode_num,

Line 873: UPDATE gmd_composite_results

869: c_temp_table_cmpt_row.mode_char);
870: l_place := 55;
871:
872: --rboddu Modified the following update statement to update gmd_composite_results with median_num, median_char selected from c_temp_table_cmpt. bug 3571258
873: UPDATE gmd_composite_results
874: SET in_spec_ind = l_in_spec,
875: mean= c_temp_table_cmpt_row.mean ,
876: mode_num= c_temp_table_cmpt_row.mode_num,
877: mode_char = c_temp_table_cmpt_row.mode_char,

Line 924: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'GMD_COMPOSITE_RESULTS',

920: attribute30 = decode(p_copy_flex,'Y',c_temp_table_cmpt_row.attribute30, attribute30)
921: WHERE composite_result_id = c_temp_table_cmpt_row.child_result_id;
922:
923: IF (p_copy_attachment = 'Y') THEN
924: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'GMD_COMPOSITE_RESULTS',
925: X_from_pk1_value => c_temp_table_cmpt_row.parent_result_id,
926: X_to_entity_name => 'GMD_COMPOSITE_RESULTS',
927: x_to_pk1_value => c_temp_table_cmpt_row.child_result_id);
928: END IF;

Line 926: X_to_entity_name => 'GMD_COMPOSITE_RESULTS',

922:
923: IF (p_copy_attachment = 'Y') THEN
924: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'GMD_COMPOSITE_RESULTS',
925: X_from_pk1_value => c_temp_table_cmpt_row.parent_result_id,
926: X_to_entity_name => 'GMD_COMPOSITE_RESULTS',
927: x_to_pk1_value => c_temp_table_cmpt_row.child_result_id);
928: END IF;
929:
930: END LOOP;

Line 1003: FROM gmd_composite_results r,

999: r.ATTRIBUTE27,
1000: r.ATTRIBUTE28,
1001: r.ATTRIBUTE29,
1002: r.ATTRIBUTE30
1003: FROM gmd_composite_results r,
1004: gmd_composite_spec_disp a --Bug 3017743, added to get event spec disp id.
1005: WHERE r.composite_spec_disp_id = p_composite_spec_disp_id
1006: AND r.composite_spec_disp_id = a.composite_spec_disp_id
1007: AND r.parent_composite_result_id IS NOT NULL

Line 1016: FROM gmd_composite_results a, gmd_composite_spec_disp b

1012:
1013: CURSOR c_curr_compo_rec(p_event_spec_disp_id IN NUMBER,
1014: p_test_id IN NUMBER) IS
1015: SELECT composite_result_id
1016: FROM gmd_composite_results a, gmd_composite_spec_disp b
1017: WHERE a.composite_spec_disp_id = b.composite_spec_disp_id
1018: AND b.latest_ind = 'Y'
1019: AND b.event_spec_disp_id = p_event_spec_disp_id
1020: AND a.test_id = p_test_id

Line 1035: UPDATE gmd_composite_results

1031: gmd_debug.put_line('The value of test_id is '||l_previous_row.test_id);
1032: FOR l_curr_compo_rec IN c_curr_compo_rec(l_previous_row.event_spec_disp_id,
1033: l_previous_row.test_id) LOOP
1034: gmd_debug.put_line('The value of composite_result_id is '||l_curr_compo_rec.composite_result_id);
1035: UPDATE gmd_composite_results
1036: SET in_spec_ind = l_previous_row.in_spec_ind,
1037: mean= l_previous_row.mean ,
1038: mode_num= l_previous_row.mode_num,
1039: mode_char = l_previous_row.mode_char,

Line 1108: from gmd_composite_results

1104: l_place := 10;
1105: delete gmd_composite_result_assoc
1106: where composite_result_id IN
1107: (select composite_result_id
1108: from gmd_composite_results
1109: where composite_spec_disp_id = p_composite_spec_disp_id);
1110: IF (l_debug = 'Y') THEN
1111: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_result_assoc for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');
1112: END IF;

Line 1114: delete gmd_composite_results

1110: IF (l_debug = 'Y') THEN
1111: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_result_assoc for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');
1112: END IF;
1113: l_place := 20;
1114: delete gmd_composite_results
1115: where composite_spec_disp_id = p_composite_spec_disp_id;
1116:
1117: IF (l_debug = 'Y') THEN
1118: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_results for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');

Line 1118: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_results for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');

1114: delete gmd_composite_results
1115: where composite_spec_disp_id = p_composite_spec_disp_id;
1116:
1117: IF (l_debug = 'Y') THEN
1118: gmd_debug.put_line('Deleting<'||SQL%ROWCOUNT||'>gmd_composite_results for single sample sample group for composite_spec_disp_id <'||p_composite_spec_disp_id||'>');
1119: END IF;
1120:
1121: l_place := 30;
1122: delete gmd_composite_spec_disp