摘要： 1. 首先找到物料的主单位及是否可以进行单位换算。SELECT PRIMARY_UOM_CODE, ALLOWED_UNITS_LOOKUP_CODE FROM mtl_system_items msi, MTL_UNITS_OF_MEASURE MTLUOM2WHERE msi.ORGANIZATION_ID = &107 AND msi.INVENTORY_ITEM_ID = &1399007 AND MTLUOM2.uom_code = msi.PRIMARY_UOM_CODE AND NVL(MTLUOM2.DISABLE_DATE, TRUNC(SYSDATE) + 阅读全文