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.

[Home] [Help]

APPS.GMD_QMSED dependencies on GMD_SAMPLE_SPEC_DISP

Line 96: gmd_sample_spec_disp gss,

92: FROM gmd_samples a,mtl_system_items_kfv b,
93: gmd_sampling_events c,gmd_all_spec_vrs_vl d ,
94: gmd_sampling_events gse,
95: gmd_event_spec_disp ges,
96: gmd_sample_spec_disp gss,
97: mtl_parameters mp
98: WHERE
99: A.sample_id=l_event_key AND
100: a.inventory_item_id=b.inventory_item_id AND

Line 126: gmd_sample_spec_disp gss,

122: gmd_com_spec_vrs_vl d ,
123: gmd_specifications e,
124: gmd_sampling_events gse,
125: gmd_event_spec_disp ges,
126: gmd_sample_spec_disp gss,
127: mtl_parameters mp
128: WHERE
129: A.sample_id=l_event_key AND
130: a.inventory_item_id=b.inventory_item_id AND

Line 157: FROM gmd_event_spec_disp ges, gmd_sample_spec_disp gss

153: mtl_system_items_kfv b,
154: gmd_specifications_b e,
155: gmd_sampling_events gse,
156: (SELECT ges.sampling_event_id , ges.disposition ,ges.spec_vr_id,ges.spec_id
157: FROM gmd_event_spec_disp ges, gmd_sample_spec_disp gss
158: WHERE spec_used_for_lot_attrib_ind = 'Y'
159: AND ges.event_spec_disp_id = gss.event_spec_disp_id
160: AND ges.delete_mark = 0
161: AND gss.sample_id = l_event_key ) ges,

Line 191: gmd_sample_spec_disp ssd

187: ELSE
188: SELECT s.sample_id INTO l_sample_id
189: FROM gmd_samples s,
190: gmd_event_spec_disp esd,
191: gmd_sample_spec_disp ssd
192: WHERE esd.sampling_event_id = l_event_key
193: AND esd.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'
194: AND esd.sampling_event_id = s.sampling_event_id
195: AND esd. EVENT_SPEC_DISP_ID = ssd.EVENT_SPEC_DISP_ID