rfb0204421的专栏

OPM全称Oracle Process Manufacturing,即Oracle流程制造，和离散制造（Discrete Manufacturing）不同，流程制造主要应用于制药，食品行业。Process Manufacturing vs Discrete Manufacturing流程式制造(Process Manufacturing)是通过一条生产线将原料制成成品，比如集成

---create temp table for OPM formula GENERATIONCREATE TABLE DKC_FORMULA_STG(  FORMULA_NO         VARCHAR2(32),  FORMULA_VERS       NUMBER,  FORMULA_DESC       VARCHAR2(70),  FORMULA_CLASS 

-- create temp table for recipes   CREATE TABLE DKC_RECIPE_STG(  RECIPE_NO                VARCHAR2(32),  RECIPE_VER               NUMBER(5),  RECIPE_DESC              VARCHAR2(70),  RECIPE

--- CREATE TEMP TABLE FOR OperationCREATE TABLE DKC_OPRN_STG(  OPRN_NO                 VARCHAR2(16),  OPRN_DESC               VARCHAR2(40),  OPRN_VERS               NUMBER(5),  ORGANIZATIO

-- 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,