隨手筆記

update mtl_system_items_b
   set PURCHASING_ENABLED_FLAG       = 'N',
       CUSTOMER_ORDER_ENABLED_FLAG   = 'N',
       INTERNAL_ORDER_ENABLED_FLAG   = 'N',
       MTL_TRANSACTIONS_ENABLED_FLAG = 'N',
       STOCK_ENABLED_FLAG            = 'N',
       BOM_ENABLED_FLAG              = 'N',
       BUILD_IN_WIP_FLAG             = 'N',
       INVENTORY_ITEM_STATUS_CODE    = 'Inactive',
       INVOICE_ENABLED_FLAG          = 'N'
 where inventory_item_id = 341386
   and organization_id = 222 
   
   
料號生效

update mtl_system_items_b
   set PURCHASING_ENABLED_FLAG       = 'Y',
       CUSTOMER_ORDER_ENABLED_FLAG   = 'Y',
       INTERNAL_ORDER_ENABLED_FLAG   = 'Y',
       MTL_TRANSACTIONS_ENABLED_FLAG = 'Y',
       STOCK_ENABLED_FLAG            = 'Y',
       BOM_ENABLED_FLAG              = 'Y',
       BUILD_IN_WIP_FLAG             = 'Y',
       INVENTORY_ITEM_STATUS_CODE    = 'Active',
       INVOICE_ENABLED_FLAG          = 'Y'
 where inventory_item_id = 341386
   and organization_id = 222