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_QMSED dependencies on GMD_COM_SPEC_VRS_VL

Line 120: gmd_com_spec_vrs_vl d ,

116: L_SPEC_VERS, L_GRADE_CODE, L_ORGN_CODE
117: FROM gmd_samples a,
118: mtl_system_items_kfv b,
119: gmd_sampling_events c,
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,

Line 223: ,GMD_COM_SPEC_VRS_VL B

219: d.SAMPLING_PLAN_NAME||' / '||d.SAMPLING_PLAN_DESC ,e.revision, f.organization_code
220: INTO L_ITEM_NO,L_ITEM_DESC,L_LOT_NO,
221: L_SAMPLE_SOURCE,L_SPECIFICATION,L_SAMPLE_PLAN,l_item_revision,l_orgn_code
222: FROM GMD_SAMPLING_EVENTS A
223: ,GMD_COM_SPEC_VRS_VL B
224: ,MTL_SYSTEM_ITEMS_B_KFV C
225: ,GMD_SAMPLING_PLANS D
226: ,GMD_SPECIFICATIONS_B E
227: ,MTL_PARAMETERS F

Line 257: ,gmd_com_spec_vrs_vl b

253: e.revision, f.organization_code
254: INTO l_item_no,l_item_desc,l_lot_no,
255: l_sample_source,l_specification,l_item_revision,l_orgn_code
256: from gmd_sampling_events a
257: ,gmd_com_spec_vrs_vl b
258: ,mtl_system_items_b_kfv c
259: ,gmd_specifications_b e
260: ,mtl_parameters f
261: where a.original_spec_vr_id = b.spec_vr_id and

Line 291: ,GMD_COM_SPEC_VRS_VL B

287: /* SELECT c.CONCATENATED_SEGMENTS,c.DESCRIPTION,A.LOT_NUMBER,A.SOURCE,E.SPEC_NAME||' / '||to_char(E.SPEC_VERS),
288: d.SAMPLING_PLAN_NAME||' / '||d.SAMPLING_PLAN_DESC ,e.revision,f.organization_code
289: INTO L_ITEM_NO,L_ITEM_DESC,L_LOT_NO,L_SAMPLE_SOURCE,L_SPECIFICATION,L_SAMPLE_PLAN ,l_item_revision,l_orgn_code
290: FROM GMD_SAMPLING_EVENTS A
291: ,GMD_COM_SPEC_VRS_VL B
292: ,MTL_SYSTEM_ITEMS_B_KFV C
293: ,GMD_SAMPLING_PLANS D
294: ,GMD_SPECIFICATIONS_B E
295: ,MTL_PARAMETERS F

Line 324: ,gmd_com_spec_vrs_vl b

320: e.revision, f.organization_code
321: INTO l_item_no,l_item_desc,l_lot_no, l_sample_source,l_specification,
322: l_item_revision,l_orgn_code
323: from gmd_sampling_events a
324: ,gmd_com_spec_vrs_vl b
325: ,mtl_system_items_b_kfv c
326: ,gmd_specifications_b e
327: ,mtl_parameters f
328: where a.original_spec_vr_id = b.spec_vr_id and