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 581: UPDATE qc_smpl_mst

577: WHERE qc_spec_id = l_null_vendor_id_spec.qc_spec_id
578: )
579: ;
580:
581: UPDATE qc_smpl_mst
582: SET migration_status = 'VI'
583: WHERE migration_status IS NULL
584: AND sample_id IN (SELECT sample_id
585: FROM qc_rslt_mst

Line 913: UPDATE qc_smpl_mst

909: l_specs.l_b_qc_spec_id))
910: AND migration_status IS NULL;
911:
912: l_position :=220;
913: UPDATE qc_smpl_mst
914: SET migration_status = 'OL'
915: WHERE sample_id IN (SELECT sample_id
916: FROM qc_rslt_mst
917: WHERE qc_spec_id in (SELECT qc_spec_id