EGO Tables (165)
EGO - Advanced Product Catalog — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
EGO_ACTIONS_B |
15 | This table contains information about User-Defined Actions. |
EGO_ACTIONS_DL |
9 | This table is used to store the Visibility flag(enabled/disabled) for actions seperately for each data level |
EGO_ACTIONS_TL |
10 | This table contains TL related information about User-Defined Actions. Base table is EGO_ACTIONS_B |
EGO_ACTION_DISPLAYS_B |
15 | This table contains particulars for UI interface for the actions. |
EGO_ACTION_GROUPS_B |
10 | This table contains information regarding User-Defined Actions Groups. (This table is obsolete) |
EGO_ACTION_GROUPS_TL |
10 | This table contains transalated data for User-Defined Actions Groups. (This table is obsolete) |
EGO_ACTN_GRP_ENTRIES_B |
8 | This table contains the User-Defined Actions included in an User-Defined Actions Groups. (This table is obsolete) |
EGO_AML_INTF |
55 | This table is used to store the interface records for AML |
EGO_ATTR_GROUPS_DL_INTERFACE |
29 | EGO_ATTR_GROUPS_DL_INTERFACE temporarily stores the definitions for attribute group data level before loading this information into Oracle A |
EGO_ATTR_GROUPS_INTERFACE |
25 | EGO_ATTR_GROUPS_INTERFACE temporarily stores the definitions for attribute groups before loading this information into Oracle Advanced Prod |
EGO_ATTR_GROUP_COLS_INTF |
43 | EGO_ATTR_GROUP_COLS_INTF temporarily stores the definitions for attributes before loading this information into Oracle Advanced Product Cat |
EGO_ATTR_GROUP_DL |
13 | This table is used to store the data level information enabled for an attribute group. |
EGO_ATTR_GRPS_ASSOC_INTERFACE |
20 | Interface Table for associating Attribute Group to an ICC |
EGO_ATTR_MAPPING_MASTER |
13 | This table is used to store Mapping master information for a given Source System. |
EGO_ATTR_MAPPING_ROWS |
18 | This table is used to store Mapping row for each attribute. |
EGO_BULKLOAD_INTF |
742 | Place holder table to populate data from excel using result format Id into appropriate interface tables/columns. This table is for internal |
EGO_BUSINESS_EVENTS_TRACKING |
8 | This table is used to store all EGO business events name and its payload |
EGO_CATG_MAP_DTLS |
9 | This table contains the category mapping imformation. |
EGO_CATG_MAP_HDRS_B |
10 | Base table to store Category Mappings. |
EGO_CATG_MAP_HDRS_TL |
11 | Table to store translated values for Category Mapping name and description. |
EGO_CAT_GRP_MFG_ASSOCS |
8 | This table contains Preferred Manucfacturer list for a given catalog category. |
EGO_CAT_GRP_RPT_TEMPLATES |
7 | This table is used to store associations between item catalog groups and XML publisher templates |
EGO_CAT_GRP_TEMPLATES |
8 | Table contains the Catalog Category to template associations |
EGO_CRITERIA_EXT |
18 | This table is used to store the extra Matching attributes for every Criteria |
EGO_CUSTOMIZATION_EXT |
17 | This is an extension table of AK_CUSTOMIZATIONS; it adds classifications1,2,3 |
EGO_CUSTOMIZATION_RF |
14 | This table stores customizations and customizations they reference. |
EGO_DATA_LEVEL_B |
25 | This table stores the data level information for the different objects/attributes in an application. |
EGO_DATA_LEVEL_TL |
10 | This table is used to store the translatable information of data level metadata information. |
EGO_DEFAULT_OPTIONS |
9 | This table stores default values for various option_codes used for defining the system behavior during vaious assign operations like assigni |
EGO_EBI_ITEM_LOAD_LOG |
3 | |
EGO_ENTITY_DEF_SYSTEMS_B |
14 | This table stores association of Default target systems for an Entity. |
EGO_EXT_SYS_ELEMENTS |
12 | This table is used to store XML Schema Definitions. |
EGO_FLEX_VALUESET_VERSION_B |
11 | This table stores information of versioning for a value set,if it is versioned. |
EGO_FLEX_VALUE_INTF |
22 | This table stores the values of a given value set. |
EGO_FLEX_VALUE_SET_INTF |
39 | This table stores the value set. |
EGO_FLEX_VALUE_TL_INTF |
22 | This table stores valid values for flexfield segments in each of the installed languages. |
EGO_FLEX_VALUE_VERSION_B |
10 | This table stores information of versioned values for a value set,if it value set is versioned. |
EGO_FLEX_VALUE_VERSION_TL |
12 | This table stores Transalated values of a Versioned Value Set.All the translatable field like decription,translated text stores in this tabl |
EGO_FND_DESC_FLEXS_EXT |
14 | This is an extension table on FND_DESCR_FLEX_CONTEXTS |
EGO_FND_DF_COL_USGS_EXT |
22 | This table contains metadata information about Attributes |
EGO_FND_DSC_FLX_CTX_EXT |
22 | This table contains metadata information about Attribute Groups. This table is an extension on FND_DECR_FLEX_CONTEXTS. |
EGO_FND_FLX_VAL_STS_EXT |
8 | To identify the Value sets created by EGO team |
EGO_FND_OBJECTS_EXT |
14 | Wrapper for the FND_OBJECTS table for storing additional properties for the object, used by extfwk |
EGO_FUNCTIONS_B |
11 | This table stores information about User-Defined Functions |
EGO_FUNCTIONS_INTERFACE |
20 | EGO_FUNCTIONS_INTERFACE temporarily stores information about Functions. This table is used by Metadata open interface to import Functions. |
EGO_FUNCTIONS_TL |
11 | This table stores transalatable information about User-Defined Functions. Base table is EGO_FUNCTIONS_B |
EGO_FUNC_PARAMS_B |
12 | This table stores the parameters defined for a User-Defined Functions |
EGO_FUNC_PARAMS_INTERFACE |
21 | EGO_FUNC_PARAMS_INTERFACE temporarily stores information about Function Parameters. This table is used by Metadata open interface to import |
EGO_FUNC_PARAMS_MAP_INTERFACE |
27 | |
EGO_FUNC_PARAMS_TL |
11 | Hold the language dependent properties of the function parameters. Base table is EGO_FUNC_PARAMS_B |
EGO_GENERIC_TEMP |
11 | This table is for internal use by the EGO UI |
EGO_GLOBAL_BUTTON |
15 | Table for Global Buttons (This table is obsolete) |
EGO_GTIN_SETUP |
8 | This table stores the setup data for gtin |
EGO_GTN_ATTR_CHG_B |
116 | This table is used to store Pending Changes Developer Defined Attr Groups Information |
EGO_GTN_ATTR_CHG_TL |
23 | This table is used to store Pending Changes Developer Defined Attr Groups Translatable Information |
EGO_GTN_MUL_ATTR_CHG_B |
36 | This table is used to store Pending Changes Developer Defined Multirow Attr Groups Information |
EGO_GTN_MUL_ATTR_CHG_TL |
19 | This table is used to store Pending Changes Developer Defined Multirow Attr Groups Translatable Information |
EGO_ICC_VERS_INTERFACE |
20 | |
EGO_IMAGES |
14 | Information about the Images (This table is obsolete) |
EGO_IMPORT_BATCHES_B |
14 | This table stores information on import batches |
EGO_IMPORT_BATCHES_TL |
11 | This table stores translatable names of batches |
EGO_IMPORT_BATCH_CHANGES |
8 | This table stores all the change objects created for a batch |
EGO_IMPORT_COPY_OPTIONS |
12 | This table stores the options that user chooses from UI in the create/copy item flow |
EGO_IMPORT_EXCLUDED_SS_ITEMS |
8 | This table stores the excluded source system items |
EGO_IMPORT_OPTION_SETS |
35 | This table stores default options for a source system or an import batch |
EGO_INBOUND_MSG_EXT |
12 | This table stores the last message timestamp of messages received from other systems |
EGO_INCLUDED_BUSINESSENTITIES |
9 | This table stores the business entities that a ruleset includes |
EGO_INCLUDED_RULESETS |
10 | This table stores which the inclusions of one ruleset in another ruleset |
EGO_INTERFACE_TL |
13 | This table is used to store unimported translatable entries. |
EGO_ITEMS_ATTRS_CHANGES_B |
111 | Holds the data for item attributes which is to be implemented or is already implemented through a change order |
EGO_ITEMS_ATTRS_CHANGES_TL |
63 | Holds transalatable data for item attributes which is to be implemented or is already implemented through a change order |
EGO_ITEM_ASSOCIATIONS |
20 | This table is used to store item associations |
EGO_ITEM_ASSOCIATIONS_INTF |
35 | This table is used to store the interface records for item associations |
EGO_ITEM_CAT_DENORM_HIER |
2 | This table is used to store the denormalized hierarchy of item catalog groups |
EGO_ITEM_CUST_ATTRS_B |
19 | This table stores the customer specific GTIN atttributes |
EGO_ITEM_GTN_ATTRS_B |
111 | This table stores the single row, untranslated global trading item number atttributes |
EGO_ITEM_GTN_ATTRS_TL |
20 | This table stores the single row, translated global trading item number atttributes |
EGO_ITEM_MATCHES |
13 | This table stores all the matched items for a source system item within a batch. |
EGO_ITEM_PEOPLE_INTF |
29 | This is the Interface table used for Item People Grants Import. |
EGO_ITEM_PROJECTS |
14 | This table stores the associations between items/revisions and projects/tasks. |
EGO_ITEM_TEXT_TL |
15 | Table used to maintain Oracle Text Index for Item Search. |
EGO_ITEM_TP_ATTRS_EXT_B |
104 | This table stores the Trading Partner specific attribute values for an Item. This table is used in UCCnet Industry extensions. |
EGO_ITEM_TP_ATTRS_EXT_TL |
52 | This table stores the Translatable Trading Partner specific attribute values for an Item. This table is used in UCCnet Industry extensions. |
EGO_ITEM_TRANS_ATTRS_B |
18 | Proof of concept table for Transaction Attributes |
EGO_ITEM_TRANS_ATTRS_TL |
17 | This table stores the translatable transaction attribute values for an item. |
EGO_ITMATTR_APPL_USGS_B |
9 | This table stores item attributes that are "enabled" for other applications; "enabled" is interpreted per application. |
EGO_ITM_GTN_MUL_ATTRS_B |
32 | This table stores the multi row, untranslated global trading item number atttributes |
EGO_ITM_GTN_MUL_ATTRS_TL |
16 | This table stores the multi row, translated global trading item number atttributes |
EGO_ITM_USR_ATTR_INTRFC |
51 | Interface table for user attributes |
EGO_LANGUAGE_SETTINGS |
12 | Table contains Settings for Languages(This table is obsoleted) |
EGO_LCPHASE_ITEM_STATUS |
8 | This table contains phases and all possible statuses in this phase |
EGO_LCPHASE_POLICY |
10 | Table is obsoleted |
EGO_LOGIN_ITEMS_TEMP |
3 | This is a temporary table used during Item People Grants Import, to store the items accessible by the Login user |
EGO_MAPPINGS_B |
18 | Holds the mapping data for attribute to parameter mapping of a function |
EGO_MASSUPDATE_ITEM_TMP |
64 | This table holds the Item data for Mass Update flows |
EGO_MASSUPDATE_ORG_TMP |
13 | This table holds the Organization data for mass update flows |
EGO_MFG_PART_NUM_CHGS |
39 | This table stores pending and history data for Approved Manufacturers |
EGO_MINOR_REVISIONS |
30 | This table is used to store the minor revisons information for any object |
EGO_MTL_CATALOG_GRP_VERS_B |
10 | This table holds Item Catalog Category Versions data. |
EGO_MTL_SY_ITEMS_CHG_B |
400 | This table is used to store Pending Changes information for the Items |
EGO_MTL_SY_ITEMS_CHG_TL |
15 | This table is used to store Pending Changes Translatable information for the Items |
EGO_MTL_SY_ITEMS_EXT_B |
112 | Base table on EGO side to store user defined attributes |
EGO_MTL_SY_ITEMS_EXT_TL |
59 | TL table on EGO side to store user defined attributes |
EGO_MY_ITEMS |
8 | Table used to store favorite items of users. |
EGO_OBJECT_EXT_TABLES_B |
9 | Table contains the name of the tables for storing the attribute data for the given object |
EGO_OBJECT_LOCK |
15 | This table store the locking history of the object and is used to find the Lock information of object |
EGO_OBJECT_ROLES |
8 | |
EGO_OBJTYPE_ATTACH_CATS |
11 | This table is used to store object type - attachment category associations. |
EGO_OBJ_AG_ASSOCS_B |
15 | Table contains Object to Attribute group associations |
EGO_OBJ_ROLE_MAPPINGS |
11 | Table contains Mapping between different object roles |
EGO_OBJ_TYPE_LIFECYCLES |
8 | This table stores the lifecycles associated with an object - catalog_group, structure_type or relationship_type |
EGO_ODI_WS_ENTITIES |
10 | This table stores List of primary key identifiers for an entity to be published |
EGO_ODI_WS_XSL |
4 | |
EGO_ONDEMAND_RULES_ATTRS_B |
22 | |
EGO_ONDEMAND_RULES_BATCHS_B |
9 | |
EGO_ONDEMAND_RULES_ITEMS_B |
15 | |
EGO_PAGES_B |
12 | This table stores information about User-Defined Pages |
EGO_PAGES_INTERFACE |
21 | EGO_PAGES_INTERFACE temporarily stores the definitions for Item Catalog Category Pages before loading this information into Oracle Advanced |
EGO_PAGES_TL |
11 | This table stores transalatable information about User-Defined Pages |
EGO_PAGE_ENTRIES_B |
10 | This table contains the Entries in a User-Defined Page |
EGO_PAGE_ENTRIES_INTERFACE |
24 | EGO_PAGES_ENTRIES_INTERFACE temporarily stores the definitions for Item Catalog Category Page Entries before loading this information into |
EGO_PRODUCT_CAT_SET_EXT |
16 | This table is used to store sales and marketing attribute group values for product catalog |
EGO_PUBLICATION_BATCH_GT |
22 | |
EGO_PUB_BAT_ENTS_B |
13 | |
EGO_PUB_BAT_ENT_OBJS_B |
15 | |
EGO_PUB_BAT_HDR_B |
12 | |
EGO_PUB_BAT_PARAMS_B |
14 | |
EGO_PUB_BAT_STATUS_B |
11 | |
EGO_PUB_BAT_SYSTEMS_B |
8 | |
EGO_PUB_WS_CONFIG |
10 | |
EGO_PUB_WS_ENTITIES |
26 | |
EGO_PUB_WS_ERRORS |
8 | |
EGO_PUB_WS_FLAT_RECS |
25 | This table stores all entities to be published as output xml for a given xml input. |
EGO_PUB_WS_INPUT_IDENTIFIERS |
13 | |
EGO_PUB_WS_OUTPUT |
11 | This table stores output xml for a webservice call. |
EGO_PUB_WS_PARAMS |
10 | |
EGO_REPORTS |
14 | This table is used to store Report information |
EGO_REPORT_LISTS_B |
15 | This table is used to store Report List information |
EGO_REPORT_LISTS_TL |
10 | This table is used to store launguage specific information for Report List |
EGO_REPORT_LIST_ENTRIES |
8 | This table is used to store Report List Entries |
EGO_RESULTS_FMT_USAGES |
17 | Table containing Result format usages. This is internal use only. |
EGO_RULE_ASSIGNMENTS |
10 | This table stores the entity;action to which a Ruleset is assigned |
EGO_RULE_ATTRIBUTE_USAGES |
12 | This table stores the attributes that are refered/used in a rule |
EGO_RULE_SETS_B |
13 | This table is used to store the Ruleset metadata. |
EGO_RULE_SETS_TL |
11 | This table is used to store the translatable entries in Ruleset metadata. |
EGO_SKU_VARIANT_ATTR_USAGES |
9 | This table stores the concatenated value of all variant attributes for a SKU item |
EGO_SOURCE_SYSTEM_EXT |
8 | This table stores additional information about source system |
EGO_STYLE_VARIANT_ATTR_VS |
8 | This table stores the value set used by each style item for each variant attribute |
EGO_SUBTAB |
13 | This table is obsolete |
EGO_SUPPLIERSITE_TMP |
18 | This table is used to store the search results of supplier/sites during item association creation |
EGO_TAB_SETUP |
20 | This table is obsolete |
EGO_TEMPL_ATTRIBUTES |
21 | Table contains the value entered for attributes in templates |
EGO_TRANS_ATTRS_VERS_INTF |
37 | This is an interface table to store TA |
EGO_TRANS_ATTR_VERS_B |
28 | This table stores the transaction attribute values for an item. |
EGO_UCCNET_ADD_CIC_INFO |
12 | This table contains the Additional Information sent by UCCnet for CIC message. |
EGO_UCCNET_BASELINES |
32 | This table records snapshots of the last set of UCC registration attributes; it is used to determine if a current registration action is a C |
EGO_UCCNET_EVENTS |
35 | This table stores the events which are triggered by users to send messages to UCCnet |
EGO_UOM_MAPPING_MASTER |
9 | This table is used to store UOM Mapping for a given Source System. |
EGO_UOM_MAPPING_ROWS |
10 | This table is used to store mapping row for each UOM. |
EGO_USER_RULES_B |
15 | This table is used to store the individual rules metadata. |
EGO_USER_RULES_TL |
11 | This table is used to store the translatable entries in Rule metadata. |
EGO_VALUE_SET_EXT |
7 | This table is used to capture parent-child relationships between value sets. |
EGO_VS_VALUES_DISP_ORDER |
9 | This table is used to store the display order for value set values |
EGO_XML_SCHEMA_DEFINITIONS |
9 | This table is used to store XML Schema Definitions. |
MTL_ITEM_CAT_GRPS_INTERFACE |
78 | Interface table for Item Catalog Category header information |