APPS.GMD_QMSMC dependencies on GMD_COM_SPEC_VRS_VL

Line 455: from gmd_com_spec_vrs_vl sv, --gmd_all_spec_vrs sv, performance bug# 4916912

451: nvl(RESERVE_CNT_REQ, 0) reserve_cnt_req,
452: nvl(RESERVE_QTY, 0) reserve_qty,
453: nvl(ARCHIVE_CNT_REQ, 0) archive_cnt_req,
454: nvl(ARCHIVE_QTY, 0) archive_qty
455: from gmd_com_spec_vrs_vl sv, --gmd_all_spec_vrs sv, performance bug# 4916912
456: gmd_sampling_plans_b sm
457: where sv.sampling_plan_id = sm.sampling_plan_id
458: and sv.spec_vr_id = x_spec_vr_id_in;
459:

Line 496: from GMD_COM_SPEC_VRS_VL --GMD_ALL_SPEC_VRS performance bug# 4916912

492: where spec_vr_id = X_SPEC_VR_ID;
493:
494: CURSOR specvr_auto_sample(X_SPEC_VR_ID number) is
495: Select nvl(auto_sample_ind, 'N')
496: from GMD_COM_SPEC_VRS_VL --GMD_ALL_SPEC_VRS performance bug# 4916912
497: where spec_vr_id = X_SPEC_VR_ID;
498:
499: /* Given a sampling event and a retain as, gets the sample numbers */
500: CURSOR get_sample_num(x_sampling_event_in number, x_retain_as_in varchar2) is

Line 2289: FROM gmd_com_spec_vrs_vl --gmd_all_spec_vrs performance bug# 4916912

2285: AND lookup_code = x_frequency_per;
2286:
2287: CURSOR get_sampling_plan_id(x_spec_vr_id_in number) IS
2288: SELECT sampling_plan_id, nvl(lot_optional_on_sample,'N'), nvl(delayed_lot_entry,'N') -- 10406191
2289: FROM gmd_com_spec_vrs_vl --gmd_all_spec_vrs performance bug# 4916912
2290: WHERE spec_vr_id = x_spec_vr_id_in;
2291:
2292: -- Bug 5391632: added cursor below to get locator
2293: CURSOR Cur_locator(loc_id NUMBER) IS