DBA Data[Home] [Help]

APPS.GMD_QMSMC dependencies on GMD_COM_SPEC_VRS_VL

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

354: nvl(RESERVE_CNT_REQ, 0) reserve_cnt_req,
355: nvl(RESERVE_QTY, 0) reserve_qty,
356: nvl(ARCHIVE_CNT_REQ,0) archive_cnt_req,
357: nvl(ARCHIVE_QTY,0) archive_qty
358: from gmd_com_spec_vrs_vl sv, --gmd_all_spec_vrs sv, performance bug# 4916912
359: gmd_sampling_plans_b sm
360: where sv.sampling_plan_id = sm.sampling_plan_id
361: and sv.spec_vr_id = x_spec_vr_id_in ;
362:

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

397: where spec_vr_id = X_SPEC_VR_ID ;
398:
399: CURSOR specvr_auto_sample ( X_SPEC_VR_ID number) is
400: Select nvl(auto_sample_ind,'N')
401: from GMD_COM_SPEC_VRS_VL --GMD_ALL_SPEC_VRS performance bug# 4916912
402: where spec_vr_id = X_SPEC_VR_ID ;
403:
404:
405: /* Given a sampling event and a retain as, gets the sample numbers */

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

2028: AND lookup_code = x_frequency_per ;
2029:
2030: CURSOR get_sampling_plan_id (x_spec_vr_id_in number) IS
2031: SELECT sampling_plan_id
2032: FROM gmd_com_spec_vrs_vl --gmd_all_spec_vrs performance bug# 4916912
2033: WHERE spec_vr_id = x_spec_vr_id_in ;
2034:
2035: -- Bug 5391632: added cursor below to get locator
2036: CURSOR Cur_locator(loc_id NUMBER) IS