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 974: from GMD_CHANGE_DISPOSITION

970: psample_disposition OUT NOCOPY VARCHAR2 ) IS
971:
972: CURSOR get_chng_id IS
973: select max(change_disp_id)
974: from GMD_CHANGE_DISPOSITION
975: where sampling_event_id = p_sampling_event_id
976: and organization_id = p_organization_id
977: group by organization_id;
978:

Line 981: from GMD_CHANGE_DISPOSITION

977: group by organization_id;
978:
979: CURSOR get_chng_id_smpl IS
980: select max(change_disp_id)
981: from GMD_CHANGE_DISPOSITION
982: where sample_id = p_sample_id
983: and sampling_event_id = p_sampling_event_id
984: and organization_id = p_organization_id
985: group by organization_id;

Line 989: from gmd_change_disposition gcd ,gem_lookups gl

985: group by organization_id;
986:
987: CURSOR get_from_disp(p_change_disp_id IN NUMBER) IS
988: select gl.meaning
989: from gmd_change_disposition gcd ,gem_lookups gl
990: where gl.lookup_type = 'GMD_QC_SAMPLE_DISP'
991: and gl.lookup_code = gcd.disposition_from
992: and gcd.change_disp_id = p_change_disp_id;
993:

Line 996: from gmd_change_disposition gcd ,gem_lookups gl

992: and gcd.change_disp_id = p_change_disp_id;
993:
994: CURSOR get_to_disp(p_change_disp_id IN NUMBER) IS
995: select gl.meaning
996: from gmd_change_disposition gcd ,gem_lookups gl
997: where gl.lookup_type = 'GMD_QC_SAMPLE_DISP'
998: and gl.lookup_code = gcd.disposition_to
999: and gcd.change_disp_id = p_change_disp_id;
1000: