APPS.GMD_QMSED dependencies on GMD_SAMPLES

Line 92: FROM gmd_samples a,mtl_system_items_kfv b,

88: D.SPEC_VERS,D.GRADE_CODE, mp.organization_code
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,

Line 119: FROM gmd_samples a,

115: E.SPEC_VERS,E.GRADE_CODE, mp.organization_code
116: INTO L_SAMPLE_NO,L_SAMPLE_DESC,l_sampling_Event_id,L_ITEM_REVISION,L_ITEM_NO,L_ITEM_DESC,
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,

Line 152: gmd_samples a,

148: INTO L_SAMPLE_NO,L_SAMPLE_DESC,l_sampling_Event_id,L_ITEM_REVISION,L_ITEM_NO,L_ITEM_DESC,
149: L_LOT_NO,l_lpn_id,L_SAMPLE_DISPOSITION,L_SAMPLE_SOURCE,L_SPECIFICATION,
150: L_SPEC_VERS, L_GRADE_CODE, L_ORGN_CODE
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

Line 189: FROM gmd_samples s,

185: IF l_sample_event_count > 1 THEN
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'