ITPub博客

以前建錯單位了，一直沒有變更過來，因為USER無法更改PRIMARY UOM。今次在TOAD下手工UPDATE。因這是採購件，所以要資材部門在PO報價單中增加這些ITEM的KG的LINES，以後發放時就用KG的。[@more@]select a.* from mtl_system_items_b awhere segment1 in ('ZJ02070301','ZM01010032','ZJ02070112','ZJ02070197','ZJ02070006')and organization_id=806update mtl_system_items_b aset --eng_item_flag='N'a.primary_uom_code='KG',primary_unit_of_measure='KG'where segment1 in ('ZJ02070301','ZM01010032','ZJ02070112','ZJ02070197','Z