BOM Interface

最新推荐文章于 2021-04-03 09:21:44 发布

weixin_30919429

最新推荐文章于 2021-04-03 09:21:44 发布

阅读量133

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Angus/archive/2006/08/03/467063.html

一．新增

SELECT * FROM BOM.BOM_BILL_OF_MTLS_INTERFACE
SELECT * FROM BOM.BOM_INVENTORY_COMPS_INTERFACE

insert into bom.bom_bill_of_mtls_interface
(
  assembly_type, -- M / E
  assembly_item_id,
  organization_id,
  process_flag,
  transaction_type
)
values
(
   1 ,       -- assembly_type, -- M / E
   12819 ,   -- assembly_item_id,
   5138 ,    -- organization_id,
   1 ,       -- process_flag,
  'CREATE' -- transaction_type
);

insert into bom.bom_inventory_comps_interface
(
  process_flag,
  transaction_type,
  assembly_item_id ,
  organization_id ,
  assembly_item_number,
  component_quantity ,
  item_num , -- 项目序列
  operation_seq_num , -- 工序序列
  component_item_id , -- 组件
  component_item_number, -- component_item ,
  component_yield_factor , -- 产出率d1
  wip_supply_type , -- 供应类型
  OPTIONAL , -- 可选的
  MUTUALLY_EXCLUSIVE_OPTIONS, -- 互不相容
  attribute1
)
values
(
   1 ,
  'CREATE',
   12819 , -- assembly_item_id ,
   5138 , -- organization_id ,
  NULL, -- assembly_item_number, -- assembly_item ,
   5 , -- component_quantity ,
   10 , -- item_num , -- 项目序列
   1 , -- operation_seq_num , -- 工序序列
   11816 , -- component_item_id , -- 组件
  NULL, -- component_item_number, -- component_item ,
   1 , -- component_yield_factor , -- 产出率d1
   1 , -- wip_supply_type , -- 供应类型
   2 , -- OPTIONAL , -- 可选的
   2 , -- MUTUALLY_EXCLUSIVE_OPTIONS, -- 互不相容
  'A' -- ,sysdate -- attribute1
);

SELECT AA.TRANSACTION_ID,AA. * FROM BOM.BOM_BILL_OF_MTLS_INTERFACE AA;
SELECT BB.TRANSACTION_ID,BB. * FROM BOM.BOM_INVENTORY_COMPS_INTERFACE BB;
SELECT CC. * FROM INV.MTL_INTERFACE_ERRORS CC WHERE CC.TRANSACTION_ID = ' 2756981 ' ;

DELETE FROM BOM.BOM_BILL_OF_MTLS_INTERFACE
DELETE FROM BOM.BOM_INVENTORY_COMPS_INTERFACE

二．修改

（暂无）

Code Example: Bom Interface.rar

转载于:https://www.cnblogs.com/Angus/archive/2006/08/03/467063.html