APPS.GMD_QM_VALIDATE_FIX dependencies on QC_RSLT_MST

Line 55: update qc_rslt_mst

51: set qc_rec_type = 'Z'
52: where qc_rec_type is NULL
53: ;
54:
55: update qc_rslt_mst
56: set qc_rec_type = 'Z'
57: where qc_rec_type is NULL
58: ;
59:

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 330: UPDATE qc_rslt_mst r

326: -- modes.
327: --==================================================================================================================*/
328:
329: l_position :=10;
330: UPDATE qc_rslt_mst r
331: SET old_qc_spec_id = qc_spec_id ,
332: qc_spec_id = NULL
333: WHERE qc_spec_id = (
334: SELECT r.qc_spec_id

Line 369: from qc_rslt_mst r

365: where s.delete_mark = 1
366: and s.migration_status is NULL
367: and not exists (
368: select 1
369: from qc_rslt_mst r
370: where s.qc_spec_id = r.qc_spec_id );
371:
372: l_position := 35;
373:

Line 519: FROM qc_rslt_mst

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
520: WHERE qc_spec_id in (SELECT qc_spec_id
521: FROM qc_spec_mst
522: WHERE spec_hdr_id in (select
523: spec_hdr_id

Line 533: UPDATE qc_rslt_mst

529: )
530: )
531: ;
532:
533: UPDATE qc_rslt_mst
534: SET migration_status = 'VI'
535: WHERE migration_status IS NULL
536: AND sample_id in (SELECT sample_id
537: FROM qc_rslt_mst

Line 537: FROM qc_rslt_mst

533: UPDATE qc_rslt_mst
534: SET migration_status = 'VI'
535: WHERE migration_status IS NULL
536: AND sample_id in (SELECT sample_id
537: FROM qc_rslt_mst
538: WHERE qc_spec_id in (SELECT qc_spec_id
539: FROM qc_spec_mst
540: WHERE spec_hdr_id in (select
541: spec_hdr_id

Line 831: FROM qc_rslt_mst

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
833: FROM qc_spec_mst
834: WHERE spec_hdr_id in (select
835: spec_hdr_id

Line 845: UPDATE qc_rslt_mst

841: l_specs.l_b_qc_spec_id))));
842:
843:
844: l_position :=240;
845: UPDATE qc_rslt_mst
846: SET migration_status = 'OL'
847: WHERE sample_id in (SELECT sample_id
848: FROM qc_rslt_mst
849: WHERE qc_spec_id in (SELECT qc_spec_id

Line 848: FROM qc_rslt_mst

844: l_position :=240;
845: UPDATE qc_rslt_mst
846: SET migration_status = 'OL'
847: WHERE sample_id in (SELECT sample_id
848: FROM qc_rslt_mst
849: WHERE qc_spec_id in (SELECT qc_spec_id
850: FROM qc_spec_mst
851: WHERE spec_hdr_id in (select
852: spec_hdr_id