APPS.INV_UI_ITEM_LOVS dependencies on MTL_UNITS_OF_MEASURE

Line 711: --FROM mtl_units_of_measure

707: --SELECT uom_code
708: --, unit_of_measure
709: --, ''
710: --, uom_class
711: --FROM mtl_units_of_measure
712: --WHERE base_uom_flag = 'Y'
713: --AND uom_code LIKE (p_uom_code || '%')
714: --ORDER BY Upper(uom_code);
715:

Line 3956: FROM mtl_units_of_measure

3952: SELECT DISTINCT uom_code
3953: , unit_of_measure
3954: , description
3955: , uom_class
3956: FROM mtl_units_of_measure
3957: WHERE uom_code LIKE (p_uom_code);
3958: END get_all_uom_lov;
3959:
3960: -- Name: GET_INV_INSPECT_ITEM_LOV

Line 5463: FROM mtl_units_of_measure muom, wms_license_plate_numbers wlpn

5459: SELECT DISTINCT muom.uom_code
5460: , muom.unit_of_measure
5461: , muom.description
5462: , muom.uom_class
5463: FROM mtl_units_of_measure muom, wms_license_plate_numbers wlpn
5464: WHERE muom.uom_code LIKE (p_uom_text)
5465: AND wlpn.lpn_id = p_lpn_id
5466: AND muom.uom_code = wlpn.gross_weight_uom_code
5467: UNION

Line 5472: FROM mtl_units_of_measure muom, wsh_shipping_parameters wsp

5468: SELECT DISTINCT muom.uom_code
5469: , muom.unit_of_measure
5470: , muom.description
5471: , muom.uom_class
5472: FROM mtl_units_of_measure muom, wsh_shipping_parameters wsp
5473: WHERE wsp.organization_id = p_organization_id
5474: AND wsp.weight_uom_class = muom.uom_class
5475: AND muom.uom_code LIKE (p_uom_text);
5476: END get_direct_ship_uom_lov;