APPS.GMD_QMSMC dependencies on GMD_SAMPLING_PLANS_B

Line 359: gmd_sampling_plans_b sm

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

Line 375: from gmd_sampling_plans_b sm,

371: nvl(RESERVE_CNT_REQ, 0) reserve_cnt_req,
372: nvl(RESERVE_QTY, 0) reserve_qty,
373: nvl(ARCHIVE_CNT_REQ,0) archive_cnt_req,
374: nvl(ARCHIVE_QTY,0) archive_qty
375: from gmd_sampling_plans_b sm,
376: gmd_inventory_spec_vrs sv
377: where sv.sampling_plan_id = sm.sampling_plan_id
378: and sv.spec_vr_id = X_SPEC_VR_ID;
379:

Line 2019: FROM gmd_sampling_plans_b sm,

2015: nvl(RESERVE_CNT_REQ, 0) reserve_cnt_req,
2016: nvl(RESERVE_QTY, 0) reserve_qty,
2017: nvl(ARCHIVE_CNT_REQ,0) archive_cnt_req,
2018: nvl(ARCHIVE_QTY,0) archive_qty
2019: FROM gmd_sampling_plans_b sm,
2020: gmd_wip_spec_vrs sv
2021: WHERE sv.sampling_plan_id = sm.sampling_plan_id
2022: AND sv.spec_vr_id = X_SPEC_VR_ID;
2023: