[Home] [Help]
86: D.SPEC_VERS,D.GRADE_CODE, mp.organization_code
87: INTO L_SAMPLE_NO,L_SAMPLE_DESC,l_sampling_Event_id,L_ITEM_REVISION,L_ITEM_NO,L_ITEM_DESC,
88: L_LOT_NO,L_SAMPLE_DISPOSITION,L_SAMPLE_SOURCE,L_SPECIFICATION,
89: L_SPEC_VERS, L_GRADE_CODE, L_ORGN_CODE
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,
113: E.SPEC_VERS,E.GRADE_CODE, mp.organization_code
114: INTO L_SAMPLE_NO,L_SAMPLE_DESC,l_sampling_Event_id,L_ITEM_REVISION,L_ITEM_NO,L_ITEM_DESC,
115: L_LOT_NO,L_SAMPLE_DISPOSITION,L_SAMPLE_SOURCE,L_SPECIFICATION,
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,
146: INTO L_SAMPLE_NO,L_SAMPLE_DESC,l_sampling_Event_id,L_ITEM_REVISION,L_ITEM_NO,L_ITEM_DESC,
147: L_LOT_NO,L_SAMPLE_DISPOSITION,L_SAMPLE_SOURCE,L_SPECIFICATION,
148: L_SPEC_VERS, L_GRADE_CODE, L_ORGN_CODE
149: FROM
150: gmd_samples a,
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
183: IF l_sample_event_count > 1 THEN
184: l_form := 'GMDQCMPS_F:SAMPLING_EVENT_ID="'||l_event_key||'"';
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'