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

344: -- modes.
345: --==================================================================================================================*/
346:
347: l_position :=10;
348: UPDATE qc_rslt_mst r
349: SET old_qc_spec_id = qc_spec_id ,
350: qc_spec_id = NULL
351: WHERE qc_spec_id = (
352: SELECT r.qc_spec_id

Line 387: from qc_rslt_mst r

383: where s.delete_mark = 1
384: and s.migration_status is NULL
385: and not exists (
386: select 1
387: from qc_rslt_mst r
388: where s.qc_spec_id = r.qc_spec_id );
389:
390: l_position := 35;
391:

Line 585: FROM qc_rslt_mst

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
586: WHERE qc_spec_id in (SELECT qc_spec_id
587: FROM qc_spec_mst
588: WHERE spec_hdr_id in (select
589: spec_hdr_id

Line 599: UPDATE qc_rslt_mst

595: )
596: )
597: ;
598:
599: UPDATE qc_rslt_mst
600: SET migration_status = 'VI'
601: WHERE migration_status IS NULL
602: AND sample_id in (SELECT sample_id
603: FROM qc_rslt_mst

Line 603: FROM qc_rslt_mst

599: UPDATE qc_rslt_mst
600: SET migration_status = 'VI'
601: WHERE migration_status IS NULL
602: AND sample_id in (SELECT sample_id
603: FROM qc_rslt_mst
604: WHERE qc_spec_id in (SELECT qc_spec_id
605: FROM qc_spec_mst
606: WHERE spec_hdr_id in (select
607: spec_hdr_id

Line 916: FROM qc_rslt_mst

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
918: FROM qc_spec_mst
919: WHERE spec_hdr_id in (select
920: spec_hdr_id

Line 930: UPDATE qc_rslt_mst

926: l_specs.l_b_qc_spec_id))));
927:
928:
929: l_position :=240;
930: UPDATE qc_rslt_mst
931: SET migration_status = 'OL'
932: WHERE sample_id in (SELECT sample_id
933: FROM qc_rslt_mst
934: WHERE qc_spec_id in (SELECT qc_spec_id

Line 933: FROM qc_rslt_mst

929: l_position :=240;
930: UPDATE qc_rslt_mst
931: SET migration_status = 'OL'
932: WHERE sample_id in (SELECT sample_id
933: FROM qc_rslt_mst
934: WHERE qc_spec_id in (SELECT qc_spec_id
935: FROM qc_spec_mst
936: WHERE spec_hdr_id in (select
937: spec_hdr_id