APPS.WSH_WSHRDMBL_XMLP_PKG dependencies on MTL_UNITS_OF_MEASURE_VL

Line 273: MTL_UNITS_OF_MEASURE_VL

269: SELECT
270: UNIT_OF_MEASURE_TL
271: INTO L_WEIGHT_UOM
272: FROM
273: MTL_UNITS_OF_MEASURE_VL
274: WHERE UOM_CODE = WEIGHT_UOM;
275: ELSE
276: L_WEIGHT_UOM := '';
277: END IF;

Line 286: MTL_UNITS_OF_MEASURE_VL

282: CURSOR L_GET_UOM(P_VOLUME_UOM_CODE IN VARCHAR2) IS
283: SELECT
284: UNIT_OF_MEASURE_TL
285: FROM
286: MTL_UNITS_OF_MEASURE_VL
287: WHERE UOM_CODE = P_VOLUME_UOM_CODE;
288: L_VOLUME_UOM VARCHAR2(25);
289: BEGIN
290: IF VOLUME_UOM IS NOT NULL THEN

Line 328: MTL_UNITS_OF_MEASURE_VL

324: SELECT
325: UNIT_OF_MEASURE_TL
326: INTO L_WEIGHT_UNIT
327: FROM
328: MTL_UNITS_OF_MEASURE_VL
329: WHERE UOM_CODE = WEIGHT_UOM_DP;
330: ELSE
331: L_WEIGHT_UNIT := NULL;
332: END IF;

Line 347: MTL_UNITS_OF_MEASURE_VL

343: SELECT
344: UNIT_OF_MEASURE_TL
345: INTO L_VOLUME_UNIT
346: FROM
347: MTL_UNITS_OF_MEASURE_VL
348: WHERE UOM_CODE = VOLUME_UOM_DP;
349: ELSE
350: L_VOLUME_UNIT := NULL;
351: END IF;

Line 366: MTL_UNITS_OF_MEASURE_VL

362: SELECT
363: UNIT_OF_MEASURE_TL
364: INTO L_VOLUME_UNIT
365: FROM
366: MTL_UNITS_OF_MEASURE_VL
367: WHERE UOM_CODE = VOLUME_UOM_DD;
368: ELSE
369: L_VOLUME_UNIT := NULL;
370: END IF;

Line 385: MTL_UNITS_OF_MEASURE_VL

381: SELECT
382: UNIT_OF_MEASURE_TL
383: INTO L_WEIGHT_UNIT
384: FROM
385: MTL_UNITS_OF_MEASURE_VL
386: WHERE UOM_CODE = WEIGHT_UOM_DD;
387: ELSE
388: L_WEIGHT_UNIT := NULL;
389: END IF;