APPS.GMD_QMSMC dependencies on GMD_INVENTORY_SPEC_VRS

Line 376: gmd_inventory_spec_vrs sv

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:
380: CURSOR sample_plan_freq_per (x_frequency_per varchar2 ) is

Line 391: from GMD_INVENTORY_SPEC_VRS

387: /* Cursors to check if Spec VR has auto enable flag enabled */
388:
389: CURSOR inventory_auto_sample ( X_SPEC_VR_ID number) is
390: select nvl(auto_sample_ind,'N')
391: from GMD_INVENTORY_SPEC_VRS
392: where spec_vr_id = X_SPEC_VR_ID ;
393:
394: CURSOR supplier_auto_sample ( X_SPEC_VR_ID number) is
395: Select nvl(auto_sample_ind,'N')