一.新增
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
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