improt item 正确程序

--主组织存在但库存组织不存在

declare
cursor c1 is
select distinct MSI.* from item_temp a,apps.mtl_system_items msi
where a.total_item=msi.segment1
and organization_id=2
and  NOT exists (select 1 from mtl_system_items where organization_id=419 and segment1=a.total_item)
;
v1  c1%rowtype;
begin
    open c1;
    loop
    fetch c1 into v1;
    exit when c1%notfound;
    begin
    insert into mtl_system_items_interface (
 INVENTORY_ITEM_ID                      ,
 ORGANIZATION_ID                        ,
 LAST_UPDATE_DATE                       ,
 LAST_UPDATED_BY                        ,
 CREATION_DATE                          ,
 CREATED_BY                             ,
 LAST_UPDATE_LOGIN                      ,
 SUMMARY_FLAG                           ,
 ENABLED_FLAG                           ,
 START_DATE_ACTIVE                      ,
 END_DATE_ACTIVE                        ,
 DESCRIPTION                            ,
 BUYER_ID                               ,
 ACCOUNTING_RULE_ID                     ,
 INVOICING_RULE_ID                      ,
 SEGMENT1                               ,
 PURCHASING_ITEM_FLAG                   ,
 SHIPPABLE_ITEM_FLAG                    ,
 CUSTOMER_ORDER_FLAG                    ,
 INTERNAL_ORDER_FLAG                    ,
 SERVICE_ITEM_FLAG                      ,
 INVENTORY_ITEM_FLAG                    ,
 ENG_ITEM_FLAG                          ,
 INVENTORY_ASSET_FLAG                   ,
 PURCHASING_ENABLED_FLAG                ,
 CUSTOMER_ORDER_ENABLED_FLAG            ,
 INTERNAL_ORDER_ENABLED_FLAG            ,
 SO_TRANSACTIONS_FLAG                   ,
 MTL_TRANSACTIONS_ENABLED_FLAG          ,
 STOCK_ENABLED_FLAG                     ,
 BOM_ENABLED_FLAG                       ,
 BUILD_IN_WIP_FLAG                      ,
 REVISION_QTY_CONTROL_CODE              ,
 ITEM_CATALOG_GROUP_ID                  ,
 CATALOG_STATUS_FLAG                    ,
 RETURNABLE_FLAG                        ,
 DEFAULT_SHIPPING_ORG                   ,
 COLLATERAL_FLAG                        ,
 TAXABLE_FLAG                           ,
 QTY_RCV_EXCEPTION_CODE                 ,
 ALLOW_ITEM_DESC_UPDATE_FLAG            ,
 INSPECTION_REQUIRED_FLAG               ,
 RECEIPT_REQUIRED_FLAG                  ,
 MARKET_PRICE                           ,
 HAZARD_CLASS_ID                        ,
 RFQ_REQUIRED_FLAG                      ,
 QTY_RCV_TOLERANCE                      ,
 LIST_PRICE_PER_UNIT                    ,
 UN_NUMBER_ID                           ,
 PRICE_TOLERANCE_PERCENT                ,
 ASSET_CATEGORY_ID                      ,
 ROUNDING_FACTOR                        ,
 UNIT_OF_ISSUE                          ,
 ENFORCE_SHIP_TO_LOCATION_CODE          ,
 ALLOW_SUBSTITUTE_RECEIPTS_FLAG         ,
 ALLOW_UNORDERED_RECEIPTS_FLAG          ,
 ALLOW_EXPRESS_DELIVERY_FLAG            ,
 DAYS_EARLY_RECEIPT_ALLOWED             ,
 DAYS_LATE_RECEIPT_ALLOWED              ,
 RECEIPT_DAYS_EXCEPTION_CODE            ,
 RECEIVING_ROUTING_ID                   ,
 INVOICE_CLOSE_TOLERANCE                ,
 RECEIVE_CLOSE_TOLERANCE                ,
 AUTO_LOT_ALPHA_PREFIX                  ,
 START_AUTO_LOT_NUMBER                  ,
 LOT_CONTROL_CODE                       ,
 SHELF_LIFE_CODE                        ,
 SHELF_LIFE_DAYS                        ,
 SERIAL_NUMBER_CONTROL_CODE             ,
 START_AUTO_SERIAL_NUMBER               ,
 AUTO_SERIAL_ALPHA_PREFIX               ,
 SOURCE_TYPE                            ,
 SOURCE_ORGANIZATION_ID                 ,
 SOURCE_SUBINVENTORY                    ,
 EXPENSE_ACCOUNT                        ,
 ENCUMBRANCE_ACCOUNT                    ,
 RESTRICT_SUBINVENTORIES_CODE           ,
 UNIT_WEIGHT                            ,
 WEIGHT_UOM_CODE                        ,
 VOLUME_UOM_CODE                        ,
 UNIT_VOLUME                            ,
 RESTRICT_LOCATORS_CODE                 ,
 LOCATION_CONTROL_CODE                  ,
 SHRINKAGE_RATE                         ,
 ACCEPTABLE_EARLY_DAYS                  ,
 PLANNING_TIME_FENCE_CODE               ,
 DEMAND_TIME_FENCE_CODE                 ,
 LEAD_TIME_LOT_SIZE                     ,
 STD_LOT_SIZE                           ,
 CUM_MANUFACTURING_LEAD_TIME            ,
 OVERRUN_PERCENTAGE                     ,
 MRP_CALCULATE_ATP_FLAG                 ,
 ACCEPTABLE_RATE_INCREASE               ,
 ACCEPTABLE_RATE_DECREASE               ,
 CUMULATIVE_TOTAL_LEAD_TIME             ,
 PLANNING_TIME_FENCE_DAYS               ,
 DEMAND_TIME_FENCE_DAYS                 ,
 END_ASSEMBLY_PEGGING_FLAG              ,
 REPETITIVE_PLANNING_FLAG               ,
 PLANNING_EXCEPTION_SET                 ,
 BOM_ITEM_TYPE                          ,
 PICK_COMPONENTS_FLAG                   ,
 REPLENISH_TO_ORDER_FLAG                ,
 BASE_ITEM_ID                           ,
 ATP_COMPONENTS_FLAG                    ,
 ATP_FLAG                               ,
 FIXED_LEAD_TIME                        ,
 VARIABLE_LEAD_TIME                     ,
 WIP_SUPPLY_LOCATOR_ID                  ,
 WIP_SUPPLY_TYPE                        ,
 WIP_SUPPLY_SUBINVENTORY                ,
 PRIMARY_UOM_CODE                       ,
 PRIMARY_UNIT_OF_MEASURE                ,
 ALLOWED_UNITS_LOOKUP_CODE              ,
 COST_OF_SALES_ACCOUNT                  ,
 SALES_ACCOUNT                          ,
 DEFAULT_INCLUDE_IN_ROLLUP_FLAG         ,
 INVENTORY_ITEM_STATUS_CODE             ,
 INVENTORY_PLANNING_CODE                ,
 PLANNER_CODE                           ,
 PLANNING_MAKE_BUY_CODE                 ,
 FIXED_LOT_MULTIPLIER                   ,
 ROUNDING_CONTROL_TYPE                  ,
 CARRYING_COST                          ,
 POSTPROCESSING_LEAD_TIME               ,
 PREPROCESSING_LEAD_TIME                ,
 FULL_LEAD_TIME                         ,
 ORDER_COST                             ,
 MRP_SAFETY_STOCK_PERCENT               ,
 MRP_SAFETY_STOCK_CODE                  ,
 MIN_MINMAX_QUANTITY                    ,
 MAX_MINMAX_QUANTITY                    ,
 MINIMUM_ORDER_QUANTITY                 ,
 FIXED_ORDER_QUANTITY                   ,
 FIXED_DAYS_SUPPLY                      ,
 MAXIMUM_ORDER_QUANTITY                 ,
 ATP_RULE_ID                            ,
 PICKING_RULE_ID                        ,
 RESERVABLE_TYPE                        ,
 POSITIVE_MEASUREMENT_ERROR             ,
 NEGATIVE_MEASUREMENT_ERROR             ,
 ENGINEERING_ECN_CODE                   ,
 ENGINEERING_ITEM_ID                    ,
 ENGINEERING_DATE                       ,
 SERVICE_STARTING_DELAY                 ,
 VENDOR_WARRANTY_FLAG                   ,
 SERVICEABLE_COMPONENT_FLAG             ,
 SERVICEABLE_PRODUCT_FLAG               ,
 BASE_WARRANTY_SERVICE_ID               ,
 PAYMENT_TERMS_ID                       ,
 PREVENTIVE_MAINTENANCE_FLAG            ,
 PRIMARY_SPECIALIST_ID                  ,
 SECONDARY_SPECIALIST_ID                ,
 SERVICEABLE_ITEM_CLASS_ID              ,
 TIME_BILLABLE_FLAG                     ,
 MATERIAL_BILLABLE_FLAG                 ,
 EXPENSE_BILLABLE_FLAG                  ,
 PRORATE_SERVICE_FLAG                   ,
 COVERAGE_SCHEDULE_ID                   ,
 SERVICE_DURATION_PERIOD_CODE           ,
 SERVICE_DURATION                       ,
 WARRANTY_VENDOR_ID                     ,
 MAX_WARRANTY_AMOUNT                    ,
 RESPONSE_TIME_PERIOD_CODE              ,
 RESPONSE_TIME_VALUE                    ,
 NEW_REVISION_CODE                      ,
 INVOICEABLE_ITEM_FLAG                  ,
 TAX_CODE                               ,
 INVOICE_ENABLED_FLAG                   ,
 MUST_USE_APPROVED_VENDOR_FLAG          ,
 REQUEST_ID                             ,
 PROGRAM_APPLICATION_ID                 ,
 PROGRAM_ID                             ,
 PROGRAM_UPDATE_DATE                    ,
 OUTSIDE_OPERATION_FLAG                 ,
 OUTSIDE_OPERATION_UOM_TYPE             ,
 SAFETY_STOCK_BUCKET_DAYS               ,
 AUTO_REDUCE_MPS                        ,
 COSTING_ENABLED_FLAG                   ,
 CYCLE_COUNT_ENABLED_FLAG               ,
-- DEMAND_SOURCE_LINE                     ,
-- COPY_ITEM_ID                           ,
-- SET_ID                                 ,
 REVISION                               ,
 AUTO_CREATED_CONFIG_FLAG               ,
 ITEM_TYPE                              ,
 MODEL_CONFIG_CLAUSE_NAME               ,
 SHIP_MODEL_COMPLETE_FLAG               ,
 MRP_PLANNING_CODE                      ,
 RETURN_INSPECTION_REQUIREMENT          ,
-- DEMAND_SOURCE_TYPE                     ,
-- DEMAND_SOURCE_HEADER_ID                ,
-- TRANSACTION_ID                         ,
 PROCESS_FLAG                           ,
-- ORGANIZATION_CODE                      ,
 ITEM_NUMBER                            ,
-- COPY_ITEM_NUMBER                       ,
-- TEMPLATE_ID                            ,
-- TEMPLATE_NAME                          ,
-- COPY_ORGANIZATION_ID                   ,
-- COPY_ORGANIZATION_CODE                 ,
 ATO_FORECAST_CONTROL                   ,
 TRANSACTION_TYPE                       ,
 MATERIAL_COST                          ,
-- MATERIAL_SUB_ELEM                      ,
-- MATERIAL_OH_RATE                       ,
-- MATERIAL_OH_SUB_ELEM                   ,
-- MATERIAL_SUB_ELEM_ID                   ,
-- MATERIAL_OH_SUB_ELEM_ID                ,
-- AUTO_REL_TIME_FENCE_CODE               ,
-- AUTO_REL_TIME_FENCE_DAYS               ,
 CONTAINER_ITEM_FLAG                    ,
 VEHICLE_ITEM_FLAG                      ,
 MAXIMUM_LOAD_WEIGHT                    ,
 MINIMUM_FILL_PERCENT                   ,
 CONTAINER_TYPE_CODE                    ,
 INTERNAL_VOLUME                        ,
 SET_PROCESS_ID                  ,
 PURCHASING_TAX_CODE                    )
 values (
  NULL,--INVENTORY_ITEM_ID                      ,
 419,--ORGANIZATION_ID                        ,
 sysdate,--LAST_UPDATE_DATE                       ,
 1231,--LAST_UPDATED_BY                        ,
 sysdate,--CREATION_DATE                          ,
 1231,--CREATED_BY                             ,
 v1.LAST_UPDATE_LOGIN                      ,
 v1.SUMMARY_FLAG                           ,
 v1.ENABLED_FLAG                           ,
 v1.START_DATE_ACTIVE                      ,
 v1.END_DATE_ACTIVE                        ,
 v1.DESCRIPTION                            ,
 v1.BUYER_ID                               ,
 v1.ACCOUNTING_RULE_ID                     ,
 v1.INVOICING_RULE_ID                      ,
 v1.SEGMENT1                               ,
 v1.PURCHASING_ITEM_FLAG                   ,
 v1.SHIPPABLE_ITEM_FLAG                    ,
 v1.CUSTOMER_ORDER_FLAG                    ,
 v1.INTERNAL_ORDER_FLAG                    ,
 v1.SERVICE_ITEM_FLAG                      ,
 v1.INVENTORY_ITEM_FLAG                    ,
 v1.ENG_ITEM_FLAG                          ,
 v1.INVENTORY_ASSET_FLAG                   ,
 v1.PURCHASING_ENABLED_FLAG                ,
 v1.CUSTOMER_ORDER_ENABLED_FLAG            ,
 v1.INTERNAL_ORDER_ENABLED_FLAG            ,
 v1.SO_TRANSACTIONS_FLAG                   ,
 v1.MTL_TRANSACTIONS_ENABLED_FLAG          ,
 v1.STOCK_ENABLED_FLAG                     ,
 v1.BOM_ENABLED_FLAG                       ,
 v1.BUILD_IN_WIP_FLAG                      ,
 v1.REVISION_QTY_CONTROL_CODE              ,
 v1.ITEM_CATALOG_GROUP_ID                  ,
 v1.CATALOG_STATUS_FLAG                    ,
 v1.RETURNABLE_FLAG                        ,
 v1.DEFAULT_SHIPPING_ORG                   ,
 v1.COLLATERAL_FLAG                        ,
 v1.TAXABLE_FLAG                           ,
 v1.QTY_RCV_EXCEPTION_CODE                 ,
 v1.ALLOW_ITEM_DESC_UPDATE_FLAG            ,
 v1.INSPECTION_REQUIRED_FLAG               ,
 v1.RECEIPT_REQUIRED_FLAG                  ,
 v1.MARKET_PRICE                           ,
 v1.HAZARD_CLASS_ID                        ,
 v1.RFQ_REQUIRED_FLAG                      ,
 v1.QTY_RCV_TOLERANCE                      ,
 v1.LIST_PRICE_PER_UNIT                    ,
 v1.UN_NUMBER_ID                           ,
 v1.PRICE_TOLERANCE_PERCENT                ,
 v1.ASSET_CATEGORY_ID                      ,
 v1.ROUNDING_FACTOR                        ,
 v1.UNIT_OF_ISSUE                          ,
 v1.ENFORCE_SHIP_TO_LOCATION_CODE          ,
 v1.ALLOW_SUBSTITUTE_RECEIPTS_FLAG         ,
 v1.ALLOW_UNORDERED_RECEIPTS_FLAG          ,
 v1.ALLOW_EXPRESS_DELIVERY_FLAG            ,
 v1.DAYS_EARLY_RECEIPT_ALLOWED             ,
 v1.DAYS_LATE_RECEIPT_ALLOWED              ,
 v1.RECEIPT_DAYS_EXCEPTION_CODE            ,
 v1.RECEIVING_ROUTING_ID                   ,
 v1.INVOICE_CLOSE_TOLERANCE                ,
 v1.RECEIVE_CLOSE_TOLERANCE                ,
 v1.AUTO_LOT_ALPHA_PREFIX                  ,
 v1.START_AUTO_LOT_NUMBER                  ,
 v1.LOT_CONTROL_CODE                       ,
 v1.SHELF_LIFE_CODE                        ,
 v1.SHELF_LIFE_DAYS                        ,
 v1.SERIAL_NUMBER_CONTROL_CODE             ,
 v1.START_AUTO_SERIAL_NUMBER               ,
 v1.AUTO_SERIAL_ALPHA_PREFIX               ,
 v1.SOURCE_TYPE                            ,
 v1.SOURCE_ORGANIZATION_ID                 ,
 v1.SOURCE_SUBINVENTORY                    ,
 v1.EXPENSE_ACCOUNT                        ,
 v1.ENCUMBRANCE_ACCOUNT                    ,
 v1.RESTRICT_SUBINVENTORIES_CODE           ,
 v1.UNIT_WEIGHT                            ,
 v1.WEIGHT_UOM_CODE                        ,
 v1.VOLUME_UOM_CODE                        ,
 v1.UNIT_VOLUME                            ,
 v1.RESTRICT_LOCATORS_CODE                 ,
 v1.LOCATION_CONTROL_CODE                  ,
 v1.SHRINKAGE_RATE                         ,
 v1.ACCEPTABLE_EARLY_DAYS                  ,
 v1.PLANNING_TIME_FENCE_CODE               ,
 v1.DEMAND_TIME_FENCE_CODE                 ,
 v1.LEAD_TIME_LOT_SIZE                     ,
 v1.STD_LOT_SIZE                           ,
 v1.CUM_MANUFACTURING_LEAD_TIME            ,
 v1.OVERRUN_PERCENTAGE                     ,
 v1.MRP_CALCULATE_ATP_FLAG                 ,
 v1.ACCEPTABLE_RATE_INCREASE               ,
 v1.ACCEPTABLE_RATE_DECREASE               ,
 v1.CUMULATIVE_TOTAL_LEAD_TIME             ,
 v1.PLANNING_TIME_FENCE_DAYS               ,
 v1.DEMAND_TIME_FENCE_DAYS                 ,
 v1.END_ASSEMBLY_PEGGING_FLAG              ,
 v1.REPETITIVE_PLANNING_FLAG               ,
 v1.PLANNING_EXCEPTION_SET                 ,
 v1.BOM_ITEM_TYPE                          ,
 v1.PICK_COMPONENTS_FLAG                   ,
 v1.REPLENISH_TO_ORDER_FLAG                ,
 v1.BASE_ITEM_ID                           ,
 v1.ATP_COMPONENTS_FLAG                    ,
 v1.ATP_FLAG                               ,
 v1.FIXED_LEAD_TIME                        ,
 v1.VARIABLE_LEAD_TIME                     ,
 NULL,--V1.WIP_SUPPLY_LOCATOR_ID                  ,
 NULL,--v1.WIP_SUPPLY_TYPE                        ,
 NULL,--v1.WIP_SUPPLY_SUBINVENTORY                ,
v1.PRIMARY_UOM_CODE                       ,
v1.PRIMARY_UNIT_OF_MEASURE                ,
 v1.ALLOWED_UNITS_LOOKUP_CODE              ,
 v1.COST_OF_SALES_ACCOUNT                  ,
 v1.SALES_ACCOUNT                          ,
 v1.DEFAULT_INCLUDE_IN_ROLLUP_FLAG         ,
 v1.INVENTORY_ITEM_STATUS_CODE             ,
 v1.INVENTORY_PLANNING_CODE                ,
 'NBPMC'    ,--v1.PLANNER_CODE                           ,
 v1.PLANNING_MAKE_BUY_CODE                 ,
 v1.FIXED_LOT_MULTIPLIER                   ,
 v1.ROUNDING_CONTROL_TYPE                  ,
 v1.CARRYING_COST                          ,
 v1.POSTPROCESSING_LEAD_TIME               ,
 v1.PREPROCESSING_LEAD_TIME                ,
 v1.FULL_LEAD_TIME                         ,
 v1.ORDER_COST                             ,
 v1.MRP_SAFETY_STOCK_PERCENT               ,
 v1.MRP_SAFETY_STOCK_CODE                  ,
 v1.MIN_MINMAX_QUANTITY                    ,
 v1.MAX_MINMAX_QUANTITY                    ,
 v1.MINIMUM_ORDER_QUANTITY                 ,
 v1.FIXED_ORDER_QUANTITY                   ,
 v1.FIXED_DAYS_SUPPLY                      ,
 v1.MAXIMUM_ORDER_QUANTITY                 ,
 v1.ATP_RULE_ID                            ,
 v1.PICKING_RULE_ID                        ,
 v1.RESERVABLE_TYPE                        ,
 v1.POSITIVE_MEASUREMENT_ERROR             ,
 v1.NEGATIVE_MEASUREMENT_ERROR             ,
 v1.ENGINEERING_ECN_CODE                   ,
 v1.ENGINEERING_ITEM_ID                    ,
 v1.ENGINEERING_DATE                       ,
 v1.SERVICE_STARTING_DELAY                 ,
 v1.VENDOR_WARRANTY_FLAG                   ,
 v1.SERVICEABLE_COMPONENT_FLAG             ,
 v1.SERVICEABLE_PRODUCT_FLAG               ,
 v1.BASE_WARRANTY_SERVICE_ID               ,
 v1.PAYMENT_TERMS_ID                       ,
 v1.PREVENTIVE_MAINTENANCE_FLAG            ,
 v1.PRIMARY_SPECIALIST_ID                  ,
 v1.SECONDARY_SPECIALIST_ID                ,
 v1.SERVICEABLE_ITEM_CLASS_ID              ,
 v1.TIME_BILLABLE_FLAG                     ,
 v1.MATERIAL_BILLABLE_FLAG                 ,
 v1.EXPENSE_BILLABLE_FLAG                  ,
 v1.PRORATE_SERVICE_FLAG                   ,
 v1.COVERAGE_SCHEDULE_ID                   ,
 v1.SERVICE_DURATION_PERIOD_CODE           ,
 v1.SERVICE_DURATION                       ,
 v1.WARRANTY_VENDOR_ID                     ,
 v1.MAX_WARRANTY_AMOUNT                    ,
 v1.RESPONSE_TIME_PERIOD_CODE              ,
 v1.RESPONSE_TIME_VALUE                    ,
 v1.NEW_REVISION_CODE                      ,
 v1.INVOICEABLE_ITEM_FLAG                  ,
 v1.TAX_CODE                               ,
 v1.INVOICE_ENABLED_FLAG                   ,
 v1.MUST_USE_APPROVED_VENDOR_FLAG          ,
 v1.REQUEST_ID                             ,
 v1.PROGRAM_APPLICATION_ID                 ,
 v1.PROGRAM_ID                             ,
 v1.PROGRAM_UPDATE_DATE                    ,
 v1.OUTSIDE_OPERATION_FLAG                 ,
 v1.OUTSIDE_OPERATION_UOM_TYPE             ,
 v1.SAFETY_STOCK_BUCKET_DAYS               ,
 v1.AUTO_REDUCE_MPS                        ,
 v1.COSTING_ENABLED_FLAG                   ,
 v1.CYCLE_COUNT_ENABLED_FLAG               ,
-- v1.DEMAND_SOURCE_LINE                     ,
-- v1.COPY_ITEM_ID                           ,
-- v1.SET_ID                                 ,
1,--v1.REVISION_QTY_CONTROL_CODE                ,
 v1.AUTO_CREATED_CONFIG_FLAG               ,
 v1.ITEM_TYPE                              ,
 v1.MODEL_CONFIG_CLAUSE_NAME               ,
 v1.SHIP_MODEL_COMPLETE_FLAG               ,
 v1.MRP_PLANNING_CODE                      ,
 v1.RETURN_INSPECTION_REQUIREMENT          ,
-- v1.DEMAND_SOURCE_TYPE                     ,
-- v1.DEMAND_SOURCE_HEADER_ID                ,
-- v1.TRANSACTION_ID                         ,
 1,--PROCESS_FLAG                           ,
-- v1.ORGANIZATION_CODE                      ,
 null,--ITEM_NUMBER                            ,
-- COPY_ITEM_NUMBER                       ,
-- v1.TEMPLATE_ID                            ,
-- v1.TEMPLATE_NAME                          ,
-- COPY_ORGANIZATION_ID                   ,
-- COPY_ORGANIZATION_CODE                 ,
 v1.ATO_FORECAST_CONTROL                   ,
 'CREATE',--TRANSACTION_TYPE                       ,
0,-- v1.MATERIAL_COST                          ,
-- v1.MATERIAL_SUB_ELEM                      ,
-- v1.MATERIAL_OH_RATE                       ,
-- v1.MATERIAL_OH_SUB_ELEM                   ,
-- v1.MATERIAL_SUB_ELEM_ID                   ,
-- v1.MATERIAL_OH_SUB_ELEM_ID                ,
-- v1.AUTO_REL_TIME_FENCE_CODE               ,
-- v1.AUTO_REL_TIME_FENCE_DAYS               ,
 v1.CONTAINER_ITEM_FLAG                    ,
 v1.VEHICLE_ITEM_FLAG                      ,
 v1.MAXIMUM_LOAD_WEIGHT                    ,
 v1.MINIMUM_FILL_PERCENT                   ,
 v1.CONTAINER_TYPE_CODE                    ,
 v1.INTERNAL_VOLUME                        ,
 0,--SET_PROCESS_ID                  ,
 v1.PURCHASING_TAX_CODE                    );
EXCEPTION
WHEN OTHERS THEN
  NULL;
END ;
END LOOP;
COMMIT;
CLOSE C1;
END;

 ---导入物料到主组织中

 declare
cursor c1 is
select a.* from item_temp a
where  not exists (select 1 from mtl_system_items where organization_id =2 and segment1=a.total_item)
;
v1  c1%rowtype;
begin
    open c1;
    loop
    fetch c1 into v1;
    exit when c1%notfound;
    begin
 insert into
    mtl_system_items_interface (organization_id, process_flag , transaction_type, segment1, description)
values(2, 1, 'CREATE', v1.total_item, v1.description) ;
EXCEPTION
WHEN OTHERS THEN
  NULL;
END ;
END LOOP;
COMMIT;
CLOSE C1;
END;

 
 
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12122734/viewspace-507971/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/12122734/viewspace-507971/

多智能体-系统-形成-控制 附matlab代码.rar 立即下载

相关推荐

具有PWM控制VSC-HVDC链路的IEEE30总线传输系统(Simulink仿真实现)

内容概要:本文构建了一个包含PWM控制VSC-HVDC链路的IEEE30节点电力传输系统,并基于Simulink平台完成了系统的建模仿真。该模型聚焦于高压直流输电(HVDC)技术在区域电网互联中的应用,采用电压源型换流器(VSC)与脉宽调制(PWM)技术实现高效、灵活的电能传输。研究重点在于分析VSC-HVDC链路在复杂多节点电网中对潮流分布、系统稳定性及电能质量的调控能力,特别关注其在区域电网互联、新能源大规模接入以及跨区域电力交换等场景下的动态响应特性与控制性能,为现代智能电网的发展提供技术支撑与仿真验证手段。; 适合人群:具备电力系统、电气工程或自动化等相关专业背景的研究生、科研人员及工程技术人员。; 使用场景及目标:①用于研究VSC-HVDC在多节点电网(如IEEE30节点)中的建模与仿真方法;②分析PWM控制策略下HVDC链路对电网潮流分布、电压稳定性和故障穿越能力的影响;③为区域电网互联、新能源并网及智能电网调度等课题提供仿真基础和技术验证。; 阅读建议:此资源以Simulink仿真实现为核心,建议读者在掌握电力电子技术和电力系统分析基础知识的前提下,结合仿真模型深入理解VSC-HVDC的工作原理与控制策略。在学习过程中,应着重关注模型参数设置、控制环路设计及仿真结果的分析,以达到理论与实践相结合的目的。

mtl_system_items_b表中的栏位与界面栏位对应

Introduction The basic table mtl_system_items_b is the basic table of item in ERP system and there are a lot of columns,but I don’t know used of each column,particularly the column like '%_flag'. The

huangwenkangz的博客 9872

基于KDE-CDF置信带的不确定综合能源系统鲁棒调度优化研究(Matlab代码实现)

内容概要:本研究针对不确定综合能源系统中的鲁棒调度优化问题,提出一种基于核密度估计-累积分布函数(KDE-CDF)置信带的建模方法,用以精确刻画风能、光伏及负荷等不确定性因素的非正态概率分布特征。通过构建KDE-CDF模型,能够有效捕捉实际运行中新能源出力与负荷需求的波动性与随机性,并在此基础上设计鲁棒优化调度框架,提升系统在不确定性环境下的运行可靠性与经济性。该方法结合Matlab编程实现,综合考虑系统运行成本、峰谷差、碳排放等多重目标,实现多维度协调优化。研究还探讨了与智能优化算法(如粒子群算法)相结合的应用路径,增强了模型的求解效率与工程实用性,为含多种储能装置、电转气设备及碳捕集系统的复杂综合能源系统提供了科学的调度决策支持。; 适合人群:具备电力系统分析、优化理论基础及Matlab编程能力的研究生、科研人员,以及从事综合能源系统规划、运行与调度工作的工程技术人员。; 使用场景及目标:①解决高比例可再生能源接入背景下综合能源系统调度中的不确定性建模难题;②提升调度方案在面对新能源强波动性时的鲁棒性与适应能力;③为融合多类型灵活性资源(如储能、电转气、碳捕集)的综合能源系统提供精细化、可落地的优化运行策略。; 阅读建议:建议读者在掌握概率统计、随机优化与电力系统运行基础知识的前提下,结合文中提供的Matlab代码进行实践操作,重点关注KDE-CDF置信带的构建流程及其在鲁棒优化模型中的嵌入机制,通过调整输入数据分布、参数设置与场景配置开展仿真对比实验,深入理解不确定性建模精度对调度决策质量的影响,进而掌握从数据驱动角度提升系统鲁棒性的关键技术路径。

【转】INV模块常用表结构

【转】INV模块常用表结构 INV模块常用表结构 表名:inv.mtl_system_items 说明: 物料主表 列名 类型 含义 ORGANIZATION_ID NUMBER 组织代码 INVENTORY_ITEM_ID NUMBER 项目内码 SEGMENT1 VARCHAR2(40) 项目编码(外码) UNIT_OF_ISSUE 单位 DESCRIPTION 项目说明 ALLOWED_UNITS_LOOKUP_CODE 可否单位换算 INVENTORY_ITEM_STATUS...

AlexLiu_2019的博客 1278

含分布式电源的配电网可靠性评估研究(Matlab代码实现)

内容概要:本文系统研究了含分布式电源的配电网可靠性评估方法,基于Matlab代码实现了完整的评估模型与算法框架。研究深入分析了分布式电源接入后对配电网结构与运行特性的影响,重点探讨了其对供电可靠性的作用机制。采用序贯蒙特卡洛模拟法对系统各类状态进行抽样与仿真,综合考虑了分布式电源出力的随机性、负荷波动性以及网络拓扑变化等多种不确定性因素,精确计算了系统及负荷点的多项可靠性指标。通过在标准测试系统上的仿真实验,验证了所提方法的有效性和实用性,为新型电力系统环境下配电网的规划、运行与可靠性提升提供了有力的技术支撑和决策依据。; 适合人群:具备电力系统分析、概率统计及可靠性基础理论知识,熟悉Matlab编程语言,从事电力系统规划、运行、可靠性评估等相关工作的科研人员、高校研究生以及电力行业工程师。; 使用场景及目标:①掌握含分布式电源的现代配电网可靠性评估的核心理论与关键技术;②学习并实践基于序贯蒙特卡洛模拟的电力系统可靠性分析算法的Matlab实现方法;③为实际工程中分布式电源的优化配置、配电网的升级改造以及制定可靠性提升策略提供科学的仿真工具和量化分析依据。; 阅读建议:建议读者结合文中提供的Matlab代码,逐行阅读并运行程序,重点理解系统建模、状态抽样、潮流计算与指标统计等核心模块的实现逻辑。可尝试调整分布式电源的类型、容量、接入位置及负荷水平等参数,观察其对系统可靠性指标的影响趋势,从而深化对系统动态行为与关键影响因素的理解。

退出微软账户-解除微软账户绑定 .exe

退出微软账户_解除微软账户绑定小工具

EBS 物料属性 先后台对应关系 MTL_SYSTEM_ITEMS_B

计划方法:mrp_planning_code(未计划:6,MRP计划:3,MPS计划:4,MPS/MRP计划:7,MPS/MPP计划:8,MPP计划:9)序列—生成: serial_number_control_code(不控制:1,接受时:5,发放销售订单时:6,预约义:2)供应类型: wip_supply_type(推式:1,装配拉式:2,工序拉式:3,批量:4,供应商:5,虚拟:6)BOM物料类型:bom_item_type(标准:4,模型:1,选件类:2,计划:3,产品系列:5)

biqidaoer的专栏 2165

大学生职业生涯规划.pptx

大学生职业生涯规划.pptx

Oracle EBS ego_item_pub.assign_item_to_org 物料分配组织出错

/* 下列某个属性中存在主项 - 子项之间的冲突: 需求时间范围 (DEMAND_TIME_FENCE_CODE)、 提前期批量 (LEAD_TIME_LOT_SIZE)、 标准批量 (STD_LOT_SIZE)、 累计制造 (CUM_MANUFACTURING_LEAD_TIME)、 超出百分比 (OVERRUN_PERCENTAGE)、 计算 ATP (MRP_CALCULATE_ATP_FLAG)、 生产率增加允差 (ACCEPTABLE_RATE_INCREASE)、 生产率减少允差 (ACCEP.

chenfei829的专栏 1283

Vivaldi天线HFSS建模实战:从参数化曲线到辐射优化的完整流程

本文详细介绍了Vivaldi天线在HFSS中的建模与优化全流程,涵盖参数化曲线绘制、馈电系统设计及性能验证等关键步骤。通过实战案例分享,帮助工程师掌握超宽带天线的HFSS建模技巧,提升雷达探测和通信系统设计效率。重点解析了指数渐变曲线建模、微带馈电优化等核心技术要点。

weixin_29228781的博客 277

基于java实现的弹幕视频网站

开发语言:Java框架:ssm技术:JSPJDK版本:JDK1.8服务器:tomcat7数据库:mysql 5.7(一定要5.7版本)数据库工具:Navicat11开发软件:eclipse/myeclipse/ideaMaven包:Maven3.3.9系统展示弹幕视频网站,在弹幕视频网站可以查看首页、视频信息、商品信息、论坛信息、我的、跳转到后台、购物车、客服等内容前台首页界面图登录,通过登录填写账号、密码等信息进行登录操作登录界面图视频信息界面图。

DC5621的博客 1334

主物料界面数据来源

它的源程序是“#:\oracle\visappl\inv\11.5.0\forms\US\INVIDITM.fmx”。 数据来源:视图MTL_SYSTEM_ITEMS_FVL 来源的两张表MTL_SYSTEM_ITEMS_B MTL_SYSTEM_ITEMS_TL 操作数据: CREATE OR REPLACE VIEW "APP...

525

ENSP:小型企业网络拓扑设计

包含的技术:ospf、dhcp中继、ac+ap、vrrp+mstp、acl、浮动路由、静态路由、vlan划分

weixin_45921302的博客 1万+

improt bom正确程序

declarecursor c1 is--select * from mtl_system_items where organization_id=299--and segment1='5KB1-3100010'-- sele...

cuixie7913的博客 159

八大核心深度学习算法详解:从CNN到Transformer的完整指南

深度学习作为人工智能的核心技术,通过多层神经网络模拟人脑学习机制。其基本原理是利用反向传播算法优化网络参数,从数据中自动提取特征表示。这一技术价值在于能够处理高维复杂数据,在图像识别、自然语言处理等领域实现突破性进展。卷积神经网络(CNN)通过局部连接和权值共享有效处理图像数据,而Transformer架构基于自注意力机制革新了序列建模方式。在实际工程实践中,CNN广泛应用于计算机视觉任务,如图像分类和目标检测;Transformer则成为自然语言处理的主流架构,支撑着BERT、GPT等预训练模型。本文系统

aoe41606的博客 432

Day01 Geant4学习

​ 用来记录粒子在每个step中的信息的,例如位置,能量,动量.例如,假设每一个粒子都有一个属于自己的id,会记录自己的轨迹状态信息就是track,当他发生反应时,就会产生新的id。​ 最终在新建的build文件夹中的vis.mac文件中设置,是自带的,如果有更高的需求可以自己去更改,但是一般都是写好的,设置好了图形界面的一些东西,呈现的自己建模的图形界面多大,需不需要网格什么的。从反应到结束的过程,其中也包括它产生的刺激粒子的反应到结束的过程,成为一个事件event。

LXS_357的博客 934

oracle ebs 应付api,[转载]Oracle EBS 常见API上

Order Import Interface (Sales OrderConversion)Interface tables·OE_HEADERS_IFACE_ALL·OE_LINES_IFACE_ALL·OE_ACTIONS_IFACE_ALL·OE_ORDER_SOURCES·OE_CUSTOMER_INFO_IFACE_ALL·OE_PRICE_ADJS_IFACE_ALL·O...

weixin_29219539的博客 294

PSO算法介绍

结合网上的文章对PSO进行一些介绍,并附上自己复现的算法。

Witty_Hou的博客 1万+

Tab键窄化补全:提升编码效率的编辑器交互模式

代码补全是现代集成开发环境(IDE)和代码编辑器的核心功能,它基于语言服务器协议(LSP)或静态分析,为开发者提供上下文感知的代码建议。其原理是通过分析当前代码的语法树和语义信息,实时匹配并推荐可能的变量、函数或关键字。这项技术的核心价值在于减少人工输入错误、加速开发流程并辅助代码探索。在实际工程实践中,高效的补全交互能极大提升开发者的心流状态。常见的应用场景包括快速导入模块、补全对象方法或生成代码模板。本文聚焦于一种名为“Tab键窄化补全”的高阶交互模式,它通过将**实时输入作为筛选器**,并利用**Ta

weixin_30615767的博客 428

C# ArcGIS Engine二次开发——实现“加载shp文件”

private void AddShpDataToolStripMenuItem_Click(object sender, EventArgs e) { OpenFileDialog OpFileDialog=new OpenFileDialog();//OpenFileDialog:打开文件对话框 OpFileDialog.Title="添加矢量数据"; OpFileDialog.Filter="(*.shp)|*.shp";//filter:过滤器;"(*.shp)|*.shp"

weixin_42191203的博客 5258

UFAST车道线检测 Ultra-Fast-Lane-Detection 从环境搭建到复现完成(一)

UFAST车道线检测 Ultra-Fast-Lane-Detection 从环境搭建到复现完成(一)

m0_46364958的博客 4345

Java Static Import的用法

在头部使用的imoirt static ***方式叫做静态引入,在Java SE 1.5.0(JDK 5)引入的特性。 官方文档的介绍: 为了访问静态成员,有必要限定它们来自的类的引用。例如,必须这样使用: double r = Math.cos(Math.PI * theta); 为了解决这个问题,人们有时会把静态成员放到一个接口中,并从这个接口...

weixin_33910434的博客 80

Statistics and Machine Learning Toolbox

Statistics and Machine Learning Toolbox(带书签),MATLAB统计学习工具

oracle erp account generator,转:Oracle ERP 技术

INV中期末关帐时不计成本如何解决INV在期末关帐的时候经常出现不计成本的错误,这些错误很大的原因时Cost manager运行有问题,或者没有起来,或者运行用错误,但是如果Costmanager也没有什么问题,就很少的几条记录因为其它不知名原因出现了不计成本的错误导致没有办法关帐.下面的SQL可以解决:第一段處理(子庫移轉)update mtl_material_transactionsset ...

weixin_39735005的博客 466

IDEA的使用指南

IDEA基于java的使用手册,可以最快速的上手,在使用中不断的丰富自己的使用技巧.

深度学习工具包 DeepLearningToolbox

深度学习工具包Deprecation notice.-----This toolbox is outdated and no longer maintained.There are much better tools available for deep learning than this toolbox, e.g. [Theano](http://deeplearning.net/software/theano/), [torch](http://torch.ch/) or [tensorflow](http://www.tensorflow.org/)I would suggest you use one of the tools mentioned above rather than use this toolbox.Best, Rasmus.DeepLearnToolbox================A Matlab toolbox for Deep Learning.Deep Learning is a new subfield of machine learning that focuses on learning deep hierarchical models of data.It is inspired by the human brain's apparent deep (layered, hierarchical) architecture.A good overview of the theory of Deep Learning theory is[Learning Deep Architectures for AI](http://www.iro.umontreal.ca/~bengioy/papers/ftml_book.pdf)For a more informal introduction, see the following videos by Geoffrey Hinton and Andrew Ng.* [The Next Generation of Neural Networks](http://www.youtube.com/watch?v=AyzOUbkUf3M) (Hinton, 2007)* [Recent Developments in Deep Learning](http://www.youtube.com/watch?v=VdIURAu1-aU) (Hinton, 2010)* [Unsupervised Feature Learning and Deep Learning](http://www.youtube.com/watch?v=ZmNOAtZIgIk) (Ng, 2011)If you use this toolbox in your research please cite [Prediction as a candidate for learning deep hierarchical models of data](http://www2.imm.dtu.dk/pubdb/views/publication_details.php?id=6284)```@MASTERSTHESIS\{IMM2012-06284, author = "R. B. Palm", title = "Prediction as a candidate for learning deep hierarchical models of data", year = "2012",}```Contact: rasmusbergpalm at gmail dot comDirectories included in the toolbox-----------------------------------`NN/` - A library for Feedforward Backpropagation Neural Networks`CNN/` - A library for Convolutional Neural Networks`DBN/` - A library for Deep Belief Networks`SAE/` - A library for Stacked Auto-Encoders`CAE/` - A library for Convolutional Auto-Encoders`util/` - Utility functions used by the libraries`data/` - Data used by the examples`tests/` - unit tests to verify toolbox is workingFor references on each library check REFS.mdSetup-----1. Download.2. addpath(genpath('DeepLearnToolbox'));Example: Deep Belief Network---------------------```matlabfunction test_example_DBNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit RBM and visualize its weightsrand('state',0)dbn.sizes = [100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);figure; visualize(dbn.rbm{1}.W'); % Visualize the RBM weights%% ex2 train a 100-100 hidden unit DBN and use its weights to initialize a NNrand('state',0)%train dbndbn.sizes = [100 100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);%unfold dbn to nnnn = dbnunfoldtonn(dbn, 10);nn.activation_function = 'sigm';%train nnopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.10, 'Too big error');```Example: Stacked Auto-Encoders---------------------```matlabfunction test_example_SAEload mnist_uint8;train_x = double(train_x)/255;test_x = double(test_x)/255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit SDAE and use it to initialize a FFNN% Setup and train a stacked denoising autoencoder (SDAE)rand('state',0)sae = saesetup([784 100]);sae.ae{1}.activation_function = 'sigm';sae.ae{1}.learningRate = 1;sae.ae{1}.inputZeroMaskedFraction = 0.5;opts.numepochs = 1;opts.batchsize = 100;sae = saetrain(sae, train_x, opts);visualize(sae.ae{1}.W{1}(:,2:end)')% Use the SDAE to initialize a FFNNnn = nnsetup([784 100 10]);nn.activation_function = 'sigm';nn.learningRate = 1;nn.W{1} = sae.ae{1}.W{1};% Train the FFNNopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.16, 'Too big error');```Example: Convolutional Neural Nets---------------------```matlabfunction test_example_CNNload mnist_uint8;train_x = double(reshape(train_x',28,28,60000))/255;test_x = double(reshape(test_x',28,28,10000))/255;train_y = double(train_y');test_y = double(test_y');%% ex1 Train a 6c-2s-12c-2s Convolutional neural network %will run 1 epoch in about 200 second and get around 11% error. %With 100 epochs you'll get around 1.2% errorrand('state',0)cnn.layers = { struct('type', 'i') %input layer struct('type', 'c', 'outputmaps', 6, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %sub sampling layer struct('type', 'c', 'outputmaps', 12, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %subsampling layer};cnn = cnnsetup(cnn, train_x, train_y);opts.alpha = 1;opts.batchsize = 50;opts.numepochs = 1;cnn = cnntrain(cnn, train_x, train_y, opts);[er, bad] = cnntest(cnn, test_x, test_y);%plot mean squared errorfigure; plot(cnn.rL);assert(er<0.12, 'Too big error');```Example: Neural Networks---------------------```matlabfunction test_example_NNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);% normalize[train_x, mu, sigma] = zscore(train_x);test_x = normalize(test_x, mu, sigma);%% ex1 vanilla neural netrand('state',0)nn = nnsetup([784 100 10]);opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samples[nn, L] = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.08, 'Too big error');%% ex2 neural net with L2 weight decayrand('state',0)nn = nnsetup([784 100 10]);nn.weightPenaltyL2 = 1e-4; % L2 weight decayopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex3 neural net with dropoutrand('state',0)nn = nnsetup([784 100 10]);nn.dropoutFraction = 0.5; % Dropout fraction opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex4 neural net with sigmoid activation functionrand('state',0)nn = nnsetup([784 100 10]);nn.activation_function = 'sigm'; % Sigmoid activation functionnn.learningRate = 1; % Sigm require a lower learning rateopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex5 plotting functionalityrand('state',0)nn = nnsetup([784 20 10]);opts.numepochs = 5; % Number of full sweeps through datann.output = 'softmax'; % use softmax outputopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex6 neural net with sigmoid activation and plotting of validation and training error% split training data into training and validation datavx = train_x(1:10000,:);tx = train_x(10001:end,:);vy = train_y(1:10000,:);ty = train_y(10001:end,:);rand('state',0)nn = nnsetup([784 20 10]); nn.output = 'softmax'; % use softmax outputopts.numepochs = 5; % Number of full sweeps through dataopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, tx, ty, opts, vx, vy); % nntrain takes validation set as last two arguments (optionally)[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');```[![Bitdeli Badge](https://d2weczhvl823v0.cloudfront.net/rasmusbergpalm/deeplearntoolbox/trend.png)](https://bitdeli.com/free "Bitdeli Badge")

oracle erp 库存相关,oracle erp库存模块表(INV)

RECEIPT_DAYS_EXCEPTION_CODE 接收天数例外代码 RESTRICT_SUBINVENTORIES_CODE 子库存限制 ACCEPTABLE_RATE_DECREASE 可接受减少率 END_ASSEMBLY_PEGGING_FLAG 是否是最终装配 PLANNING_EXCEPTION_SET 计划例外设置 ROUNDING_CONTROL_TYPE 四舍五入控制 FIX...

weixin_42496673的博客 706

ET2012新版免狗免安装绿色软件

ET2012新版免狗免安祖昂绿色软件。,新界面,新视觉,

oracle erp 表结构

BOM模块常用表结构 表名: bom.bom_bill_of_materials 说明: BOM清单父项目 BILL_SEQUENCE_ID NUMBER 清单序号(关键字)ASSEMBLY_ITEM_ID NUMBER 装配件内码ORGANIZATION_ID NUMBER 组织代码ASSEMBLY_TYPE NUMBER 装配类别SPECFIIC_ASSEMBLY_COMMENT VAR...

weixin_30834783的博客 2591
上一篇: itpub down
下一篇: conn
cuixie7913
博客等级 码龄11年 10粉丝 0原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付:10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值