E-Business Suite 11i: EGO_MTL_SY_ITEMS_EXT_B
Oracle December 19th, 2006
APC(高级产品目录)是EBS相对较新的功能，其数据库中的表前缀通常为EGO。不过目前关于这方面的资料很少，我的TRM中也没有找到Oracle官方的说明。
今后打算陆续整理相关的表和视图的含义。但不包括文档已经详细说明或字面信息明确的内容。
SQL> desc EGO_MTL_SY_ITEMS_EXT_B Name Null? Type ------------------------------- -------- ---- EXTENSION_ID NOT NULL NUMBER(15) ORGANIZATION_ID NOT NULL NUMBER(15) INVENTORY_ITEM_ID NOT NULL NUMBER(15) REVISION_ID NUMBER(15) ITEM_CATALOG_GROUP_ID NOT NULL NUMBER(15) Item所属分类，参考视图 EGO_CATALOG_GROUPS_V。 ATTR_GROUP_ID NOT NULL NUMBER(15) 对于C_EXT_ATTR[N]、N_EXT_ATTR[N]等各字段含义的归类。 比如物料属性，物品所属工程等都可以在这里体现。 分类信息参考视图：EGO_ATTR_GROUPS_V。 CREATED_BY NOT NULL NUMBER(15) CREATION_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER(15) LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATE_LOGIN NUMBER(15) C_EXT_ATTR1 VARCHAR2(150) C_EXT_ATTR2 VARCHAR2(150) C_EXT_ATTR3 VARCHAR2(150) C_EXT_ATTR4 VARCHAR2(150) C_EXT_ATTR5 VARCHAR2(150) C_EXT_ATTR6 VARCHAR2(150) C_EXT_ATTR7 VARCHAR2(150) C_EXT_ATTR8 VARCHAR2(150) C_EXT_ATTR9 VARCHAR2(150) C_EXT_ATTR10 VARCHAR2(150) C_EXT_ATTR11 VARCHAR2(150) C_EXT_ATTR12 VARCHAR2(150) C_EXT_ATTR13 VARCHAR2(150) C_EXT_ATTR14 VARCHAR2(150) C_EXT_ATTR15 VARCHAR2(150) C_EXT_ATTR16 VARCHAR2(150) C_EXT_ATTR17 VARCHAR2(150) C_EXT_ATTR18 VARCHAR2(150) C_EXT_ATTR19 VARCHAR2(150) C_EXT_ATTR20 VARCHAR2(150) N_EXT_ATTR1 NUMBER UOM_EXT_ATTR1 VARCHAR2(3) N_EXT_ATTR2 NUMBER UOM_EXT_ATTR2 VARCHAR2(3) N_EXT_ATTR3 NUMBER UOM_EXT_ATTR3 VARCHAR2(3) N_EXT_ATTR4 NUMBER UOM_EXT_ATTR4 VARCHAR2(3) N_EXT_ATTR5 NUMBER UOM_EXT_ATTR5 VARCHAR2(3) N_EXT_ATTR6 NUMBER UOM_EXT_ATTR6 VARCHAR2(3) N_EXT_ATTR7 NUMBER UOM_EXT_ATTR7 VARCHAR2(3) N_EXT_ATTR8 NUMBER UOM_EXT_ATTR8 VARCHAR2(3) N_EXT_ATTR9 NUMBER UOM_EXT_ATTR9 VARCHAR2(3) N_EXT_ATTR10 NUMBER UOM_EXT_ATTR10 VARCHAR2(3) D_EXT_ATTR1 DATE D_EXT_ATTR2 DATE D_EXT_ATTR3 DATE D_EXT_ATTR4 DATE D_EXT_ATTR5 DATE C_EXT_ATTR21 VARCHAR2(150) C_EXT_ATTR22 VARCHAR2(150) C_EXT_ATTR23 VARCHAR2(150) C_EXT_ATTR24 VARCHAR2(150) C_EXT_ATTR25 VARCHAR2(150) C_EXT_ATTR26 VARCHAR2(150) C_EXT_ATTR27 VARCHAR2(150) C_EXT_ATTR28 VARCHAR2(150) C_EXT_ATTR29 VARCHAR2(150) C_EXT_ATTR30 VARCHAR2(150) C_EXT_ATTR31 VARCHAR2(150) C_EXT_ATTR32 VARCHAR2(150) C_EXT_ATTR33 VARCHAR2(150) C_EXT_ATTR34 VARCHAR2(150) C_EXT_ATTR35 VARCHAR2(150) C_EXT_ATTR36 VARCHAR2(150) C_EXT_ATTR37 VARCHAR2(150) C_EXT_ATTR38 VARCHAR2(150) C_EXT_ATTR39 VARCHAR2(150) C_EXT_ATTR40 VARCHAR2(150) N_EXT_ATTR11 NUMBER UOM_EXT_ATTR11 VARCHAR2(3) N_EXT_ATTR12 NUMBER UOM_EXT_ATTR12 VARCHAR2(3) N_EXT_ATTR13 NUMBER UOM_EXT_ATTR13 VARCHAR2(3) N_EXT_ATTR14 NUMBER UOM_EXT_ATTR14 VARCHAR2(3) N_EXT_ATTR15 NUMBER UOM_EXT_ATTR15 VARCHAR2(3) N_EXT_ATTR16 NUMBER UOM_EXT_ATTR16 VARCHAR2(3) N_EXT_ATTR17 NUMBER UOM_EXT_ATTR17 VARCHAR2(3) N_EXT_ATTR18 NUMBER UOM_EXT_ATTR18 VARCHAR2(3) N_EXT_ATTR19 NUMBER UOM_EXT_ATTR19 VARCHAR2(3) N_EXT_ATTR20 NUMBER UOM_EXT_ATTR20 VARCHAR2(3) D_EXT_ATTR6 DATE D_EXT_ATTR7 DATE D_EXT_ATTR8 DATE D_EXT_ATTR9 DATE D_EXT_ATTR10 DATE PROGRAM_APPLICATION_ID NUMBER PROGRAM_ID NUMBER PROGRAM_UPDATE_DATE DATE REQUEST_ID NUMBER