APPS.GMD_RESULTS_GRP dependencies on GMD_COM_SPEC_VRS_VL

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

2140: AND st.exclude_ind IS NULL
2141: AND st.test_method_id = tm.test_method_id
2142: ;
2143:
2144: --RLNAGARA Bug # 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl
2145: CURSOR c_vrs_vw (p_spec_vr_id NUMBER) IS
2146: SELECT spec_id
2147: FROM gmd_com_spec_vrs_vl
2148: WHERE spec_vr_id = p_spec_vr_id

Line 2147: FROM gmd_com_spec_vrs_vl

2143:
2144: --RLNAGARA Bug # 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl
2145: CURSOR c_vrs_vw (p_spec_vr_id NUMBER) IS
2146: SELECT spec_id
2147: FROM gmd_com_spec_vrs_vl
2148: WHERE spec_vr_id = p_spec_vr_id
2149: ;
2150:
2151: CURSOR c_event_spec (p_sampling_event_id NUMBER, p_spec_vr_id NUMBER) IS

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

6751: , x_change_disp_to OUT NOCOPY VARCHAR2
6752: , x_return_status OUT NOCOPY VARCHAR2
6753: ) IS
6754:
6755: --RLNAGARA Bug # 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl
6756: -- Cursor
6757: CURSOR c_sample_dtl (p_sample_id NUMBER) IS
6758: SELECT se.sampling_event_id,
6759: se.sample_active_cnt,

Line 6773: gmd_com_spec_vrs_vl svr

6769: FROM gmd_sampling_events se,
6770: gmd_event_spec_disp esd,
6771: gmd_sample_spec_disp ssd,
6772: gmd_samples s,
6773: gmd_com_spec_vrs_vl svr
6774: WHERE s.sample_id = p_sample_id
6775: AND s.sampling_event_id = se.sampling_event_id
6776: AND se.sampling_event_id = esd.sampling_event_id
6777: AND esd.spec_used_for_lot_attrib_ind = 'Y'

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

7229:
7230: /*=================================================
7231: BUG#4691545 - Added organization_id to cursor.
7232: =================================================*/
7233: --RLNAGARA Bug 4918820 Changed the view from gmd_all_spec_vrs to gmd_com_spec_vrs_vl
7234: CURSOR c_spec_dtl (p_event_spec_disp_id NUMBER) IS
7235: SELECT esd.disposition,
7236: svr.control_lot_attrib_ind,
7237: svr.in_spec_lot_status_id,

Line 7241: gmd_com_spec_vrs_vl svr,

7237: svr.in_spec_lot_status_id,
7238: svr.out_of_spec_lot_status_id,
7239: svr.organization_id
7240: FROM gmd_event_spec_disp esd,
7241: gmd_com_spec_vrs_vl svr,
7242: gmd_composite_spec_disp csd
7243: WHERE esd.event_spec_disp_id = p_event_spec_disp_id
7244: AND esd.spec_used_for_lot_attrib_ind = 'Y'
7245: AND svr.spec_vr_id = esd.spec_vr_id