APPS.GMD_QMSMC dependencies on GMD_INVENTORY_SPEC_VRS

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 486: from GMD_INVENTORY_SPEC_VRS

482: /* Cursors to check if Spec VR has auto enable flag enabled */
483:
484: CURSOR inventory_auto_sample(X_SPEC_VR_ID number) is
485: select nvl(auto_sample_ind, 'N')
486: from GMD_INVENTORY_SPEC_VRS
487: where spec_vr_id = X_SPEC_VR_ID;
488:
489: CURSOR supplier_auto_sample(X_SPEC_VR_ID number) is
490: Select nvl(auto_sample_ind, 'N')