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 94: gmd_sample_spec_disp gss,

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

Line 124: gmd_sample_spec_disp gss,

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

Line 155: FROM gmd_event_spec_disp ges, gmd_sample_spec_disp gss

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

Line 189: gmd_sample_spec_disp ssd

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