DBA Data[Home] [Help]

APPS.WSH_ROUTING_REQUEST dependencies on MTL_UNITS_OF_MEASURE

Line 3017: -- mtl_units_of_measure else call wrapper api Validate_UOM

3013: -- 3.Validate item qty, weight and volume for negative.
3014: -- 4.Validate if Weight UOM is given then weight is required, vice-versa.
3015: -- 5.Validate,if Volume UOM is given then Volume is required, vice-versa.
3016: -- 6.For One time Item directly validate the UOM from
3017: -- mtl_units_of_measure else call wrapper api Validate_UOM
3018: -- 7.Validate item qty decimal precision.
3019: -- 8.Validate weight and volume UOM by calling wrapper api Validate_UOM.
3020: -- Parameters :
3021: -- IN:

Line 3055: FROM mtl_units_of_measure

3051: --This cursor is use to validate UOM for One time item, as one time item
3052: --does not inventory item id.
3053: CURSOR get_item_uom(p_uom varchar2) IS
3054: SELECT 1
3055: FROM mtl_units_of_measure
3056: WHERE uom_code = p_uom
3057: AND uom_class = 'Quantity';
3058:
3059:

Line 3184: --For One time Item directly validate the UOM from mtl_units_of_measure.

3180:
3181: IF (p_line.item_uom(p_line_index) IS NOT NULL ) THEN
3182: --{
3183: IF (p_item_id IS NULL) THEN
3184: --For One time Item directly validate the UOM from mtl_units_of_measure.
3185: IF l_debug_on THEN
3186: WSH_DEBUG_SV.logmsg(l_module_name,' Lose Item');
3187: END IF;
3188: