[Home] [Help]
78: if l_event_name = 'oracle.apps.gmd.qm.sample.disposition' then
79: l_transaction_type:='GMDQMSD';
80: l_form := 'GMDQSMPL_EDIT_F:SAMPLE_ID="'||l_event_key||'"';
81:
82: -- B 3051565 PK changed the cursor to read Sample disposition from gmd_event_spec_disp
83:
84: /*SELECT A.SAMPLE_NO,A.SAMPLE_DESC,A.SAMPLING_EVENT_ID,A.REVISION,B.CONCATENATED_SEGMENTS,B.DESCRIPTION,
85: A.LOT_NUMBER,GES.DISPOSITION,A.SOURCE,D.SPEC_NAME||' / '||to_char(D.SPEC_VERS),
86: D.SPEC_VERS,D.GRADE_CODE, mp.organization_code
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
97: A.sample_id=l_event_key AND
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
127: A.sample_id=l_event_key AND
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
158: AND ges.delete_mark = 0
159: AND gss.sample_id = l_event_key ) ges,
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'
192: AND esd.sampling_event_id = s.sampling_event_id