![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
OPM
rfb0204421
这个作者很懒,什么都没留下…
展开
-
OPM Demo Flow
OPM全称Oracle Process Manufacturing,即Oracle流程制造,和离散制造(Discrete Manufacturing)不同,流程制造主要应用于制药,食品行业。Process Manufacturing vs Discrete Manufacturing流程式制造(Process Manufacturing)是通过一条生产线将原料制成成品,比如集成转载 2013-08-20 20:47:01 · 2564 阅读 · 0 评论 -
配方导入
---create temp table for OPM formula GENERATIONCREATE TABLE DKC_FORMULA_STG( FORMULA_NO VARCHAR2(32), FORMULA_VERS NUMBER, FORMULA_DESC VARCHAR2(70), FORMULA_CLASS转载 2013-08-13 11:08:26 · 1426 阅读 · 0 评论 -
处方导入
-- create temp table for recipes CREATE TABLE DKC_RECIPE_STG( RECIPE_NO VARCHAR2(32), RECIPE_VER NUMBER(5), RECIPE_DESC VARCHAR2(70), RECIPE转载 2013-08-13 11:13:28 · 1846 阅读 · 0 评论 -
工序导入
--- CREATE TEMP TABLE FOR OperationCREATE TABLE DKC_OPRN_STG( OPRN_NO VARCHAR2(16), OPRN_DESC VARCHAR2(40), OPRN_VERS NUMBER(5), ORGANIZATIO转载 2013-08-13 11:14:18 · 1514 阅读 · 0 评论 -
工艺路线导入
-- CREATE TEMP TABLE FOR ROUTINGS...CREATE TABLE DKC_ROUTINGS_STG( OWNER_ORGN_CODE VARCHAR2(4), ROUTING_NO VARCHAR2(32), ROUTING_VERSION NUMBER(5), ROUTING_QTY NUMBER,转载 2013-08-13 15:16:27 · 1448 阅读 · 0 评论