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_QUALITY_GRP dependencies on GMD_SAMPLES

Line 572: From gmd_samples s, gmd_results r

568: -- B3698232 Added dispostion 'In-Progress' and 'Complete' for single sample
569: -- AND sd.disposition IN ('4A','5AV')
570: AND sd.disposition IN ('2I', '3C', '4A','5AV')
571: AND EXISTS (Select 1
572: From gmd_samples s, gmd_results r
573: Where s.sample_id = r.sample_id
574: AND r.test_id = p_inv_rslt_inp_rec.test_id
575: AND s.organization_id = p_inv_rslt_inp_rec.organization_id
576: AND s.delete_mark = 0

Line 585: FROM gmd_samples smp, gmd_sample_spec_disp sd

581:
582: CURSOR get_samples(vSampling_Event_Id NUMBER,
583: vEvent_spec_disp_id NUMBER) IS
584: SELECT smp.sample_id
585: FROM gmd_samples smp, gmd_sample_spec_disp sd
586: WHERE smp.sampling_event_id = vSampling_Event_Id
587: AND smp.organization_id = p_inv_rslt_inp_rec.organization_id
588: AND smp.sample_id = sd.sample_id
589: AND sd.event_spec_disp_id = vEvent_spec_disp_id