APPS.WSH_UTIL_VALIDATE dependencies on MTL_UNITS_OF_MEASURE

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

1077: --========================================================================
1078: -- PROCEDURE : Validate_Uom
1079: --
1080: -- COMMENT : Validates UOM_Code and UOM Description against table
1081: -- mtl_units_of_measure. If both values are specified then
1082: -- only UOM_Code is used. Type and Organization are required
1083: -- p_type = 'WEIGHT', 'VOLUME'
1084: --========================================================================
1085:

Line 1101: FROM mtl_units_of_measure

1097:
1098: -- Bug 3821688 Split Cursor
1099: CURSOR check_uom_code (l_class VARCHAR2) IS
1100: SELECT uom_code
1101: FROM mtl_units_of_measure
1102: WHERE uom_code = p_uom_code AND
1103: uom_class = NVL(l_class, uom_class) AND
1104: nvl(disable_date, sysdate) >= sysdate;
1105:

Line 1108: FROM mtl_units_of_measure

1104: nvl(disable_date, sysdate) >= sysdate;
1105:
1106: CURSOR check_uom_desc (l_class VARCHAR2) IS
1107: SELECT uom_code
1108: FROM mtl_units_of_measure
1109: WHERE unit_of_measure = p_uom_desc AND
1110: uom_class = NVL(l_class, uom_class) AND
1111: nvl(disable_date, sysdate) >= sysdate;
1112: