APPS.INV_UI_ITEM_LOVS dependencies on MTL_UNITS_OF_MEASURE

Line 815: --FROM mtl_units_of_measure

811: --SELECT uom_code
812: --, unit_of_measure
813: --, ''
814: --, uom_class
815: --FROM mtl_units_of_measure
816: --WHERE base_uom_flag = 'Y'
817: --AND uom_code LIKE (p_uom_code || '%')
818: --ORDER BY Upper(uom_code);
819:

Line 4203: FROM mtl_units_of_measure

4199: SELECT DISTINCT uom_code
4200: , unit_of_measure
4201: , description
4202: , uom_class
4203: FROM mtl_units_of_measure
4204: WHERE uom_code LIKE (p_uom_code);
4205: END get_all_uom_lov;
4206:
4207: -- Name: GET_INV_INSPECT_ITEM_LOV

Line 5764: FROM mtl_units_of_measure muom, wms_license_plate_numbers wlpn

5760: SELECT DISTINCT muom.uom_code
5761: , muom.unit_of_measure
5762: , muom.description
5763: , muom.uom_class
5764: FROM mtl_units_of_measure muom, wms_license_plate_numbers wlpn
5765: WHERE muom.uom_code LIKE (p_uom_text)
5766: AND wlpn.lpn_id = p_lpn_id
5767: AND muom.uom_code = wlpn.gross_weight_uom_code
5768: UNION

Line 5773: FROM mtl_units_of_measure muom, wsh_shipping_parameters wsp

5769: SELECT DISTINCT muom.uom_code
5770: , muom.unit_of_measure
5771: , muom.description
5772: , muom.uom_class
5773: FROM mtl_units_of_measure muom, wsh_shipping_parameters wsp
5774: WHERE wsp.organization_id = p_organization_id
5775: AND wsp.weight_uom_class = muom.uom_class
5776: AND muom.uom_code LIKE (p_uom_text);
5777: END get_direct_ship_uom_lov;