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 MTL_SYSTEM_ITEMS_KFV

Line 92: FROM gmd_samples a,mtl_system_items_kfv b,

88: D.SPEC_VERS,D.GRADE_CODE, mp.organization_code
89: INTO L_SAMPLE_NO,L_SAMPLE_DESC,l_sampling_Event_id,L_ITEM_REVISION,L_ITEM_NO,L_ITEM_DESC,
90: L_LOT_NO,L_SAMPLE_DISPOSITION,L_SAMPLE_SOURCE,L_SPECIFICATION,
91: L_SPEC_VERS, L_GRADE_CODE, L_ORGN_CODE
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,

Line 120: mtl_system_items_kfv b,

116: INTO L_SAMPLE_NO,L_SAMPLE_DESC,l_sampling_Event_id,L_ITEM_REVISION,L_ITEM_NO,L_ITEM_DESC,
117: L_LOT_NO,L_SAMPLE_DISPOSITION,L_SAMPLE_SOURCE,L_SPECIFICATION,
118: L_SPEC_VERS, L_GRADE_CODE, L_ORGN_CODE
119: FROM gmd_samples a,
120: mtl_system_items_kfv b,
121: gmd_sampling_events c,
122: gmd_com_spec_vrs_vl d ,
123: gmd_specifications e,
124: gmd_sampling_events gse,

Line 153: mtl_system_items_kfv b,

149: L_LOT_NO,l_lpn_id,L_SAMPLE_DISPOSITION,L_SAMPLE_SOURCE,L_SPECIFICATION,
150: L_SPEC_VERS, L_GRADE_CODE, L_ORGN_CODE
151: FROM
152: gmd_samples a,
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

Line 211: ,MTL_SYSTEM_ITEMS_KFV C

207: INTO L_ITEM_NO,L_ITEM_DESC,L_LOT_NO,
208: L_SAMPLE_SOURCE,L_SPECIFICATION,L_SAMPLE_PLAN,l_item_revision,l_orgn_code
209: FROM GMD_SAMPLING_EVENTS A
210: ,GMD_ALL_SPEC_VRS_VL B
211: ,MTL_SYSTEM_ITEMS_KFV C
212: ,GMD_SAMPLING_PLANS D
213: WHERE a.original_spec_vr_id=b.SPEC_VR_ID AND
214: b.inventory_item_id=c.inventory_item_id AND
215: a.sampling_plan_id=d.sampling_plan_id(+) AND

Line 281: ,MTL_SYSTEM_ITEMS_KFV C

277: d.SAMPLING_PLAN_NAME||' / '||d.SAMPLING_PLAN_DESC ,b.revision,b.organization_code
278: INTO L_ITEM_NO,L_ITEM_DESC,L_LOT_NO,L_SAMPLE_SOURCE,L_SPECIFICATION,L_SAMPLE_PLAN ,l_item_revision,l_orgn_code
279: FROM GMD_SAMPLING_EVENTS A
280: ,GMD_ALL_SPEC_VRS_VL B
281: ,MTL_SYSTEM_ITEMS_KFV C
282: ,GMD_SAMPLING_PLANS D
283: WHERE a.original_spec_vr_id=b.SPEC_VR_ID AND
284: b.inventory_item_id=c.inventory_item_id AND
285: a.sampling_plan_id=d.sampling_plan_id(+) AND