APPS.GMD_SAMPLES_GRP dependencies on GMD_SAMPLE_SPEC_DISP

Line 1572: FROM gmd_sample_spec_disp

1568: END IF;
1569:
1570: -- check whether the sample disposition has changed.if yes raise error
1571: SELECT disposition INTO l_compare_sample_disp
1572: FROM gmd_sample_spec_disp
1573: WHERE event_spec_disp_id = l_event_spec_disp_id
1574: AND sample_id = p_update_disp_rec.sample_id
1575: FOR UPDATE OF disposition NOWAIT ;
1576:

Line 1584: UPDATE gmd_sample_spec_disp

1580:
1581: l_position := '020' ;
1582:
1583: -- Set the disposition of the sample spec disp
1584: UPDATE gmd_sample_spec_disp
1585: SET disposition = p_to_disposition,
1586: last_updated_by = l_last_updated_by,
1587: last_update_date = l_last_update_date,
1588: last_update_login = l_last_update_login

Line 1858: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd

1854: END IF;
1855:
1856: -- get MAXIMUM sample disposition from all the samples for that event.
1857: SELECT MAX(ssd.disposition) INTO l_max_disposition
1858: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd
1859: WHERE esd.event_spec_disp_id = l_event_spec_disp_id
1860: AND esd.event_spec_disp_id = ssd.event_spec_disp_id
1861: AND esd.delete_mark = 0
1862: AND ssd.delete_mark = 0

Line 1892: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd

1888: END IF;
1889:
1890: SELECT MAX(ssd.disposition),MIN(ssd.disposition)
1891: INTO l_max_disposition,l_min_disposition
1892: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd
1893: WHERE
1894: esd.event_spec_disp_id = l_event_spec_disp_id
1895: AND esd.event_spec_disp_id = ssd.event_spec_disp_id
1896: AND esd.delete_mark = 0

Line 4675: FROM gmd_sample_spec_disp ssd,

4671: --RLNAGARA B5130051 modified parameter from sample_id to p_sample_id
4672: CURSOR Cur_disposition(p_sample_id NUMBER) IS
4673: SELECT l.lookup_code,
4674: l.meaning
4675: FROM gmd_sample_spec_disp ssd,
4676: gem_lookups l
4677: WHERE ssd.sample_id = p_sample_id
4678: AND l.lookup_type = 'GMD_QC_SAMPLE_DISP'
4679: AND l.lookup_code = ssd.disposition ;

Line 5596: FROM gmd_sample_spec_disp b,

5592: CURSOR Cur_get_sample_disposition IS
5593: SELECT b.disposition,
5594: d.meaning sample_disposition,
5595: e.meaning source
5596: FROM gmd_sample_spec_disp b,
5597: gmd_event_spec_disp c,
5598: gmd_samples s,
5599: fnd_lookup_values_vl d,
5600: fnd_lookup_values_vl e

Line 5613: FROM gmd_sample_spec_disp b,

5609: UNION
5610: SELECT b.disposition,
5611: d.meaning sample_disposition,
5612: e.meaning source
5613: FROM gmd_sample_spec_disp b,
5614: gmd_event_spec_disp c,
5615: gmd_samples s,
5616: fnd_lookup_values d,
5617: fnd_lookup_values e