APPS.GMD_RESULTS_GRP dependencies on GMD_COM_SPEC_VRS_VL

Line 2057: --RLNAGARA Bug # 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl

2053: AND st.exclude_ind IS NULL
2054: AND st.test_method_id = tm.test_method_id
2055: ;
2056:
2057: --RLNAGARA Bug # 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl
2058: CURSOR c_vrs_vw (p_spec_vr_id NUMBER) IS
2059: SELECT spec_id
2060: FROM gmd_com_spec_vrs_vl
2061: WHERE spec_vr_id = p_spec_vr_id

Line 2060: FROM gmd_com_spec_vrs_vl

2056:
2057: --RLNAGARA Bug # 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl
2058: CURSOR c_vrs_vw (p_spec_vr_id NUMBER) IS
2059: SELECT spec_id
2060: FROM gmd_com_spec_vrs_vl
2061: WHERE spec_vr_id = p_spec_vr_id
2062: ;
2063:
2064: CURSOR c_event_spec (p_sampling_event_id NUMBER, p_spec_vr_id NUMBER) IS

Line 6431: --RLNAGARA Bug # 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl

6427: , x_change_disp_to OUT NOCOPY VARCHAR2
6428: , x_return_status OUT NOCOPY VARCHAR2
6429: ) IS
6430:
6431: --RLNAGARA Bug # 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl
6432: -- Cursor
6433: CURSOR c_sample_dtl (p_sample_id NUMBER) IS
6434: SELECT se.sampling_event_id,
6435: se.sample_active_cnt,

Line 6449: gmd_com_spec_vrs_vl svr

6445: FROM gmd_sampling_events se,
6446: gmd_event_spec_disp esd,
6447: gmd_sample_spec_disp ssd,
6448: gmd_samples s,
6449: gmd_com_spec_vrs_vl svr
6450: WHERE s.sample_id = p_sample_id
6451: AND s.sampling_event_id = se.sampling_event_id
6452: AND se.sampling_event_id = esd.sampling_event_id
6453: AND esd.spec_used_for_lot_attrib_ind = 'Y'

Line 6856: --RLNAGARA Bug 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl

6852:
6853: /*=================================================
6854: BUG#4691545 - Added organization_id to cursor.
6855: =================================================*/
6856: --RLNAGARA Bug 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl
6857: CURSOR c_spec_dtl (p_event_spec_disp_id NUMBER) IS
6858: SELECT esd.disposition,
6859: svr.control_lot_attrib_ind,
6860: svr.in_spec_lot_status_id,

Line 6864: gmd_com_spec_vrs_vl svr,

6860: svr.in_spec_lot_status_id,
6861: svr.out_of_spec_lot_status_id,
6862: svr.organization_id
6863: FROM gmd_event_spec_disp esd,
6864: gmd_com_spec_vrs_vl svr,
6865: gmd_composite_spec_disp csd
6866: WHERE esd.event_spec_disp_id = p_event_spec_disp_id
6867: AND esd.spec_used_for_lot_attrib_ind = 'Y'
6868: AND svr.spec_vr_id = esd.spec_vr_id