DBA Data[Home] [Help]

APPS.WMS_CATCH_WEIGHT_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 5107: mtl_units_of_measure muom

5103: WHERE organization_id = p_organization_id
5104: AND inventory_item_id = p_inventory_item_id
5105: AND uom_class IN (SELECT uom_class
5106: FROM mtl_system_items msi,
5107: mtl_units_of_measure muom
5108: WHERE msi.inventory_item_id = p_inventory_item_id
5109: AND msi.organization_id = p_organization_id
5110: AND muom.uom_code = msi.primary_uom_code)
5111: AND uom_code LIKE (l_code)

Line 5127: FROM mtl_units_of_measure_vl

5123: l_uom_class VARCHAR2(10);
5124: BEGIN
5125: SELECT uom_class
5126: INTO l_uom_class
5127: FROM mtl_units_of_measure_vl
5128: WHERE uom_code = p_uom_code;
5129:
5130: RETURN l_uom_class;
5131: EXCEPTION