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