[Home] [Help]
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,
97: mtl_parameters mp
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,
97: mtl_parameters mp
98: WHERE
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,
125: gmd_event_spec_disp ges,
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,
127: mtl_parameters mp
128: WHERE
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
158: WHERE spec_used_for_lot_attrib_ind = 'Y'
159: AND ges.event_spec_disp_id = gss.event_spec_disp_id
176: ELSIF l_event_name = 'oracle.apps.gmd.qm.samplingevent.disposition' THEN
177:
178: /* Check to see the number of active samples in this sampling event */
179: SELECT SAMPLE_ACTIVE_CNT INTO l_sample_event_count
180: FROM gmd_Sampling_events
181: WHERE sampling_event_id = l_event_key ;
182:
183: /* If more than one active sample then go to the
184: Composite Results form; otherwise go to Samples Form */
205: A.SOURCE,SPEC_NAME||' / '||to_char(SPEC_VERS),
206: d.SAMPLING_PLAN_NAME||' / '||d.SAMPLING_PLAN_DESC ,b.revision,b.organization_code
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
220: A.SOURCE, e.SPEC_NAME||' / '||to_char(e.SPEC_VERS),
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
237: -- Rewritten the above query as part of performance bug# 5221298
238: -- Split the above SQL into following 3 SQL statements
239: select original_spec_vr_id, sampling_plan_id
240: into l_spec_vr_id, l_sampling_plan_id
241: from gmd_sampling_events
242: where sampling_event_id = l_event_key;
243:
244: IF l_sampling_plan_id IS NOT NULL THEN
245: select a.sampling_plan_name || ' / ' || b.sampling_plan_desc
254: a.source, e.spec_name||' / '||to_char(e.spec_vers),
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
275: l_form := 'GMDQCMPS_F:SAMPLING_EVENT_ID="'||l_event_key||'"';
276: /*SELECT c.CONCATENATED_SEGMENTS,c.DESCRIPTION,A.LOT_NUMBER,A.SOURCE,SPEC_NAME||' / '||to_char(SPEC_VERS),
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
288: --Rewritten the above query as part of performance bug# 4916904
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
305: -- Rewritten the above query as part of performance bug# 5221298
306: -- Split the above SQL into following 3 SQL statements
307: select original_spec_vr_id, sampling_plan_id
308: into l_spec_vr_id, l_sampling_plan_id
309: from gmd_sampling_events
310: where sampling_event_id = l_event_key;
311:
312: IF l_sampling_plan_id IS NOT NULL THEN
313: select a.sampling_plan_name || ' / ' || b.sampling_plan_desc
321: select c.concatenated_segments, c.description, a.lot_number,a.lpn_id,a.source, e.spec_name||' / '||to_char(e.spec_vers),
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