[Home] [Help]
80: if l_event_name = 'oracle.apps.gmd.qm.sample.disposition' then
81: l_transaction_type:='GMDQMSD';
82: l_form := 'GMDQSMPL_EDIT_F:SAMPLE_ID="'||l_event_key||'"';
83:
84: -- B 3051565 PK changed the cursor to read Sample disposition from gmd_event_spec_disp
85:
86: /*SELECT A.SAMPLE_NO,A.SAMPLE_DESC,A.SAMPLING_EVENT_ID,A.REVISION,B.CONCATENATED_SEGMENTS,B.DESCRIPTION,
87: A.LOT_NUMBER,GES.DISPOSITION,A.SOURCE,D.SPEC_NAME||' / '||to_char(D.SPEC_VERS),
88: D.SPEC_VERS,D.GRADE_CODE, mp.organization_code
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
99: A.sample_id=l_event_key AND
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
129: A.sample_id=l_event_key AND
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
160: AND ges.delete_mark = 0
161: AND gss.sample_id = l_event_key ) ges,
186: l_form := 'GMDQCMPS_F:SAMPLING_EVENT_ID="'||l_event_key||'"';
187: ELSE
188: SELECT s.sample_id INTO l_sample_id
189: FROM gmd_samples s,
190: gmd_event_spec_disp esd,
191: gmd_sample_spec_disp ssd
192: WHERE esd.sampling_event_id = l_event_key
193: AND esd.SPEC_USED_FOR_LOT_ATTRIB_IND = 'Y'
194: AND esd.sampling_event_id = s.sampling_event_id