[Home] [Help]
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,
95: mtl_parameters mp
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,
95: mtl_parameters mp
96: WHERE
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,
122: gmd_sampling_events gse,
123: gmd_event_spec_disp ges,
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,
125: mtl_parameters mp
126: WHERE
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
155: FROM gmd_event_spec_disp ges, gmd_sample_spec_disp gss
156: WHERE spec_used_for_lot_attrib_ind = 'Y'
157: AND ges.event_spec_disp_id = gss.event_spec_disp_id
174: ELSIF l_event_name = 'oracle.apps.gmd.qm.samplingevent.disposition' THEN
175:
176: /* Check to see the number of active samples in this sampling event */
177: SELECT SAMPLE_ACTIVE_CNT INTO l_sample_event_count
178: FROM gmd_Sampling_events
179: WHERE sampling_event_id = l_event_key ;
180:
181: /* If more than one active sample then go to the
182: Composite Results form; otherwise go to Samples Form */
203: A.SOURCE,SPEC_NAME||' / '||to_char(SPEC_VERS),
204: d.SAMPLING_PLAN_NAME||' / '||d.SAMPLING_PLAN_DESC ,b.revision,b.organization_code
205: INTO L_ITEM_NO,L_ITEM_DESC,L_LOT_NO,
206: L_SAMPLE_SOURCE,L_SPECIFICATION,L_SAMPLE_PLAN,l_item_revision,l_orgn_code
207: FROM GMD_SAMPLING_EVENTS A
208: ,GMD_ALL_SPEC_VRS_VL B
209: ,MTL_SYSTEM_ITEMS_KFV C
210: ,GMD_SAMPLING_PLANS D
211: WHERE a.original_spec_vr_id=b.SPEC_VR_ID AND
218: A.SOURCE, e.SPEC_NAME||' / '||to_char(e.SPEC_VERS),
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
235: -- Rewritten the above query as part of performance bug# 5221298
236: -- Split the above SQL into following 3 SQL statements
237: select original_spec_vr_id, sampling_plan_id
238: into l_spec_vr_id, l_sampling_plan_id
239: from gmd_sampling_events
240: where sampling_event_id = l_event_key;
241:
242: IF l_sampling_plan_id IS NOT NULL THEN
243: select a.sampling_plan_name || ' / ' || b.sampling_plan_desc
252: a.source, e.spec_name||' / '||to_char(e.spec_vers),
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
273: l_form := 'GMDQCMPS_F:SAMPLING_EVENT_ID="'||l_event_key||'"';
274: /*SELECT c.CONCATENATED_SEGMENTS,c.DESCRIPTION,A.LOT_NUMBER,A.SOURCE,SPEC_NAME||' / '||to_char(SPEC_VERS),
275: d.SAMPLING_PLAN_NAME||' / '||d.SAMPLING_PLAN_DESC ,b.revision,b.organization_code
276: INTO L_ITEM_NO,L_ITEM_DESC,L_LOT_NO,L_SAMPLE_SOURCE,L_SPECIFICATION,L_SAMPLE_PLAN ,l_item_revision,l_orgn_code
277: FROM GMD_SAMPLING_EVENTS A
278: ,GMD_ALL_SPEC_VRS_VL B
279: ,MTL_SYSTEM_ITEMS_KFV C
280: ,GMD_SAMPLING_PLANS D
281: WHERE a.original_spec_vr_id=b.SPEC_VR_ID AND
286: --Rewritten the above query as part of performance bug# 4916904
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
303: -- Rewritten the above query as part of performance bug# 5221298
304: -- Split the above SQL into following 3 SQL statements
305: select original_spec_vr_id, sampling_plan_id
306: into l_spec_vr_id, l_sampling_plan_id
307: from gmd_sampling_events
308: where sampling_event_id = l_event_key;
309:
310: IF l_sampling_plan_id IS NOT NULL THEN
311: select a.sampling_plan_name || ' / ' || b.sampling_plan_desc
319: select c.concatenated_segments, c.description, a.lot_number, a.source, e.spec_name||' / '||to_char(e.spec_vers),
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