APPS.GMD_QM_VALIDATE_FIX dependencies on QC_SMPL_MST

Line 50: update qc_smpl_mst

46: set qc_rec_type = 'Z'
47: where qc_rec_type is NULL
48: ;
49:
50: update qc_smpl_mst
51: set qc_rec_type = 'Z'
52: where qc_rec_type is NULL
53: ;
54:

Line 201: FROM qc_smpl_mst a, qc_rslt_mst b

197: AND a.from_date > a.to_date;
198:
199: CURSOR c_samples_date(p_qc_spec_id NUMBER) IS
200: SELECT min(a.sample_date) min_date, max(a.sample_date) max_date
201: FROM qc_smpl_mst a, qc_rslt_mst b
202: WHERE a.sample_id = b.sample_id
203: AND b.qc_spec_id = p_qc_spec_id;
204: -- end Bug 3542894
205:

Line 237: FROM qc_smpl_mst a, qc_rslt_mst b

233: CURSOR c_samples_a(p_from_date DATE,
234: p_to_date DATE,
235: p_a_qc_spec_id NUMBER) IS
236: SELECT max(a.sample_date) max_sample_date, count(*) cnt
237: FROM qc_smpl_mst a, qc_rslt_mst b
238: WHERE a.sample_date between p_from_date and p_to_date
239: AND a.sample_id = b.sample_id
240: AND b.qc_spec_id = p_a_qc_spec_id;
241:

Line 247: FROM qc_smpl_mst a, qc_rslt_mst b

243: CURSOR c_samples_b(p_from_date DATE,
244: p_to_date DATE,
245: p_b_qc_spec_id NUMBER) IS
246: SELECT min(a.sample_date) min_sample_date, count(*) cnt
247: FROM qc_smpl_mst a, qc_rslt_mst b
248: WHERE a.sample_date between p_from_date and p_to_date
249: AND a.sample_id = b.sample_id
250: AND b.qc_spec_id = p_b_qc_spec_id;
251:

Line 515: UPDATE qc_smpl_mst

511: WHERE qc_spec_id = l_null_vendor_id_spec.qc_spec_id
512: )
513: ;
514:
515: UPDATE qc_smpl_mst
516: SET migration_status = 'VI'
517: WHERE migration_status IS NULL
518: AND sample_id IN (SELECT sample_id
519: FROM qc_rslt_mst

Line 828: UPDATE qc_smpl_mst

824: l_specs.l_b_qc_spec_id))
825: AND migration_status IS NULL;
826:
827: l_position :=220;
828: UPDATE qc_smpl_mst
829: SET migration_status = 'OL'
830: WHERE sample_id IN (SELECT sample_id
831: FROM qc_rslt_mst
832: WHERE qc_spec_id in (SELECT qc_spec_id