APPS.GMD_QMSMC dependencies on GMD_SAMPLING_PLANS_B

Line 456: gmd_sampling_plans_b sm

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:
460: CURSOR inv_sample_plan(X_SPEC_VR_ID NUMBER) is

Line 472: from gmd_sampling_plans_b sm, gmd_inventory_spec_vrs sv

468: nvl(RESERVE_CNT_REQ, 0) reserve_cnt_req,
469: nvl(RESERVE_QTY, 0) reserve_qty,
470: nvl(ARCHIVE_CNT_REQ, 0) archive_cnt_req,
471: nvl(ARCHIVE_QTY, 0) archive_qty
472: from gmd_sampling_plans_b sm, gmd_inventory_spec_vrs sv
473: where sv.sampling_plan_id = sm.sampling_plan_id
474: and sv.spec_vr_id = X_SPEC_VR_ID;
475:
476: CURSOR sample_plan_freq_per(x_frequency_per varchar2) is

Line 2277: FROM gmd_sampling_plans_b sm, gmd_wip_spec_vrs sv

2273: nvl(RESERVE_CNT_REQ, 0) reserve_cnt_req,
2274: nvl(RESERVE_QTY, 0) reserve_qty,
2275: nvl(ARCHIVE_CNT_REQ, 0) archive_cnt_req,
2276: nvl(ARCHIVE_QTY, 0) archive_qty
2277: FROM gmd_sampling_plans_b sm, gmd_wip_spec_vrs sv
2278: WHERE sv.sampling_plan_id = sm.sampling_plan_id
2279: AND sv.spec_vr_id = X_SPEC_VR_ID;
2280:
2281: CURSOR wip_sample_plan_freq_per(x_frequency_per varchar2) IS