[Home] [Help]
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,
125: gmd_event_spec_disp ges,
126: gmd_sample_spec_disp gss,
221: d.SAMPLING_PLAN_NAME||' / '||d.SAMPLING_PLAN_DESC ,e.revision, f.organization_code
222: INTO L_ITEM_NO,L_ITEM_DESC,L_LOT_NO,
223: L_SAMPLE_SOURCE,L_SPECIFICATION,L_SAMPLE_PLAN,l_item_revision,l_orgn_code
224: FROM GMD_SAMPLING_EVENTS A
225: ,GMD_COM_SPEC_VRS_VL B
226: ,MTL_SYSTEM_ITEMS_B_KFV C
227: ,GMD_SAMPLING_PLANS D
228: ,GMD_SPECIFICATIONS_B E
229: ,MTL_PARAMETERS F
255: e.revision, f.organization_code
256: INTO l_item_no,l_item_desc,l_lot_no,l_lpn_id,
257: l_sample_source,l_specification,l_item_revision,l_orgn_code
258: from gmd_sampling_events a
259: ,gmd_com_spec_vrs_vl b
260: ,mtl_system_items_b_kfv c
261: ,gmd_specifications_b e
262: ,mtl_parameters f
263: where a.original_spec_vr_id = b.spec_vr_id and
289: /* SELECT c.CONCATENATED_SEGMENTS,c.DESCRIPTION,A.LOT_NUMBER,A.SOURCE,E.SPEC_NAME||' / '||to_char(E.SPEC_VERS),
290: d.SAMPLING_PLAN_NAME||' / '||d.SAMPLING_PLAN_DESC ,e.revision,f.organization_code
291: INTO L_ITEM_NO,L_ITEM_DESC,L_LOT_NO,L_SAMPLE_SOURCE,L_SPECIFICATION,L_SAMPLE_PLAN ,l_item_revision,l_orgn_code
292: FROM GMD_SAMPLING_EVENTS A
293: ,GMD_COM_SPEC_VRS_VL B
294: ,MTL_SYSTEM_ITEMS_B_KFV C
295: ,GMD_SAMPLING_PLANS D
296: ,GMD_SPECIFICATIONS_B E
297: ,MTL_PARAMETERS F
322: e.revision, f.organization_code
323: INTO l_item_no,l_item_desc,l_lot_no,l_lpn_id,l_sample_source,l_specification,
324: l_item_revision,l_orgn_code
325: from gmd_sampling_events a
326: ,gmd_com_spec_vrs_vl b
327: ,mtl_system_items_b_kfv c
328: ,gmd_specifications_b e
329: ,mtl_parameters f
330: where a.original_spec_vr_id = b.spec_vr_id and