_inventory_comps_interface; (导入成功后)对组件进行排序 exec cux_bom_temp.update_bill_item_num4;
select count(*) from bom_inventory_comps_interface; 24、对于接口表中的数据进行导入 delete bom_bill_of_mtls_interface; insert into bom_bill_of_mtls_interface( assembly_type,assembly_item_id, organization_id, process_flag,transaction_type) select distinct 1,assembly_item_id, 1, 1,''''CREATE'''' from cux_bill_temp;
上一页 [1] [2] |