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
5601: WHERE b.sample_id = p_sample.sample_id
5602: and b.event_spec_disp_id = c.event_spec_disp_id
5603: and c.spec_used_for_lot_attrib_ind = 'Y'
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
5601: WHERE b.sample_id = p_sample.sample_id
5602: and b.event_spec_disp_id = c.event_spec_disp_id
5603: and c.spec_used_for_lot_attrib_ind = 'Y'
5604: and b.disposition = d.lookup_code
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
5618: WHERE b.sample_id =p_sample.sample_id
5619: and b.event_spec_disp_id = c.event_spec_disp_id
5620: and c.spec_used_for_lot_attrib_ind = 'Y'
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
5618: WHERE b.sample_id =p_sample.sample_id
5619: and b.event_spec_disp_id = c.event_spec_disp_id
5620: and c.spec_used_for_lot_attrib_ind = 'Y'
5621: and b.disposition = d.lookup_code