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

ITPub博客

转:BOM Interface

最新文章