APPS.WSH_UTIL_VALIDATE dependencies on MTL_UNITS_OF_MEASURE

Line 1103: -- mtl_units_of_measure. If both values are specified then

1099: --========================================================================
1100: -- PROCEDURE : Validate_Uom
1101: --
1102: -- COMMENT : Validates UOM_Code and UOM Description against table
1103: -- mtl_units_of_measure. If both values are specified then
1104: -- only UOM_Code is used. Type and Organization are required
1105: -- p_type = 'WEIGHT', 'VOLUME'
1106: --========================================================================
1107:

Line 1123: FROM mtl_units_of_measure

1119:
1120: -- Bug 3821688 Split Cursor
1121: CURSOR check_uom_code (l_class VARCHAR2) IS
1122: SELECT uom_code
1123: FROM mtl_units_of_measure
1124: WHERE uom_code = p_uom_code AND
1125: uom_class = NVL(l_class, uom_class) AND
1126: nvl(disable_date, sysdate) >= sysdate;
1127:

Line 1130: FROM mtl_units_of_measure

1126: nvl(disable_date, sysdate) >= sysdate;
1127:
1128: CURSOR check_uom_desc (l_class VARCHAR2) IS
1129: SELECT uom_code
1130: FROM mtl_units_of_measure
1131: WHERE unit_of_measure = p_uom_desc AND
1132: uom_class = NVL(l_class, uom_class) AND
1133: nvl(disable_date, sysdate) >= sysdate;
1134: