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_QC_ERES_UTILS dependencies on GMD_CHANGE_DISPOSITION

Line 1011: from GMD_CHANGE_DISPOSITION

1007: psample_disposition OUT NOCOPY VARCHAR2 ) IS
1008:
1009: CURSOR get_chng_id IS
1010: select max(change_disp_id)
1011: from GMD_CHANGE_DISPOSITION
1012: where sampling_event_id = p_sampling_event_id
1013: and organization_id = p_organization_id
1014: group by organization_id;
1015:

Line 1018: from GMD_CHANGE_DISPOSITION

1014: group by organization_id;
1015:
1016: CURSOR get_chng_id_smpl IS
1017: select max(change_disp_id)
1018: from GMD_CHANGE_DISPOSITION
1019: where sample_id = p_sample_id
1020: and sampling_event_id = p_sampling_event_id
1021: and organization_id = p_organization_id
1022: group by organization_id;

Line 1026: from gmd_change_disposition gcd ,gem_lookups gl

1022: group by organization_id;
1023:
1024: CURSOR get_from_disp(p_change_disp_id IN NUMBER) IS
1025: select gl.meaning
1026: from gmd_change_disposition gcd ,gem_lookups gl
1027: where gl.lookup_type = 'GMD_QC_SAMPLE_DISP'
1028: and gl.lookup_code = gcd.disposition_from
1029: and gcd.change_disp_id = p_change_disp_id;
1030:

Line 1033: from gmd_change_disposition gcd ,gem_lookups gl

1029: and gcd.change_disp_id = p_change_disp_id;
1030:
1031: CURSOR get_to_disp(p_change_disp_id IN NUMBER) IS
1032: select gl.meaning
1033: from gmd_change_disposition gcd ,gem_lookups gl
1034: where gl.lookup_type = 'GMD_QC_SAMPLE_DISP'
1035: and gl.lookup_code = gcd.disposition_to
1036: and gcd.change_disp_id = p_change_disp_id;
1037: