EGO Views (98)

EGO - Advanced Product Catalog — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`EGO_ACTIONS_V`	This view contains information about User-Defined Actions.
`EGO_ACTION_DISPLAYS_V`	This view contains particulars for UI interface for the actions
`EGO_ACTION_GROUPS_V`	View contains information regarding User-Defined Actions Groups. (This table is obsolete)
`EGO_ALL_ATTR_BASE_V`	Each rov of this view displays all the information (values) associated with base and user-defined attributes for a given item.
`EGO_ALL_ATTR_LANG_V`	Each rov of this view displays all language translated information associated with base and user-defined attributes for a given item.
`EGO_ATTRS_V`	View contains metadata information about User-Defined Attributes.
`EGO_ATTR_GROUPS_DL_V`
`EGO_ATTR_GROUPS_V`	View contains metadata information about User-Defined Attribute Groups.
`EGO_ATTR_GROUP_OBJ_IDS_V`	View contains all the User-Defined Attribute Groups associated to an Object.
`EGO_ATTR_GROUP_TYPES_V`	View contains metadata information about User-Defined Attribute Group Types.
`EGO_ATTR_GROUP_TYPE_OBJ_IDS_V`	View contains all the User-Defined Attribute Group Types associated to an Object.
`EGO_CATALOG_GROUPS_V`	View on Item Catalog Categories.
`EGO_CATG_MAP_HDRS_VL`	View for Category Mappings.
`EGO_COMPANIES_V`	View contains all the Companies; Customer, Vendor and Internal
`EGO_CRITERIA_TEMPLATES_V`	This view shows all of the criteria templates that have been defined
`EGO_CRITERIA_V`	This stores all of the criteria asociated with the criteria templates
`EGO_CUSTOMER_COMPANY_V`	View contains all the Customer Companies.
`EGO_CUSTOMER_PEOPLE_V`	View contains all the Customer People.
`EGO_DATA_LEVEL_VL`	This view gives the complete information of the data level metadata.
`EGO_FINANCIAL_REPORTING_AGV`	This view is used to retrieve sales and marketing attribute group values for product catalog
`EGO_FND_OBJECTS_V`	View contains data from FND_OBJECTS and EGO_FND_OBJECTS_EXT.
`EGO_FP_DATA_TYPES_V`	View with Function Parameter types.
`EGO_FUNCTIONS_V`	View contains information about User-Defined Functions.
`EGO_FUNC_PARAMS_V`	View contains information about User-Defined Functions - Function Parameters.
`EGO_GROUPS_V`	View contains all the Groups.
`EGO_GROUP_MEMBERS_V`	This view contains the group member information
`EGO_GTIN_ATTRS_TL_V`	View for single row translated gtin attributes
`EGO_GTIN_ATTRS_V`	This view contains GTINs and all GDSN attributes (Single-row only). This view is used to send RCIR messages.
`EGO_GTIN_BARCODE_ATTRS_V`	View for bar code gtin attributes
`EGO_GTIN_COLOR_ATTRS_V`	View for Color description gtin attributes
`EGO_GTIN_COUNTRY_ORGN_V`	View for Country of origin gtin attributes
`EGO_GTIN_DELIVERY_METHOD_V`	View for Delivery Method Indicator GTIN attribute
`EGO_GTIN_HAND_INF_ATTRS_V`	View for Handling information gtin attributes
`EGO_GTIN_HARMONIZED_ID_V`	View for harmonized tariff system identification gtin attributes
`EGO_GTIN_HAZMAT_ATTRS_V`	View for Hazardous information gtin attributes
`EGO_GTIN_MFG_ATTRS_V`	View for Manufacturing information gtin attributes
`EGO_GTIN_SIZE_DESC_V`	View for Size description gtin attributes
`EGO_GTIN_TP_ATTRS_V`	View for Trading partner specific gtin attributes
`EGO_GTIN_UCCNET_HIER_ATTRS_V`	This view contains GTINs and all GDSN attributes (Single-row only). This view is used to send CIN messages.
`EGO_GTN_ATTR_CHG_VL`	This view stores pending changes information for GDSN single row attributes
`EGO_GTN_MUL_ATTR_CHG_VL`	This view stores the pending changes information for GDSN multi row attributes
`EGO_IMPORT_BATCHES_VL`	This view contains information about batches
`EGO_IMPORT_BATCH_DETAILS_V`	This view contains all details of a batch.
`EGO_INTERNAL_COMPANY_V`	View contains all the Internal Companies.
`EGO_INTERNAL_PEOPLE_V`	View contains all the Internal People.
`EGO_ITEMS_ATTRS_CHANGES_VL`	VL View that holds the data for item attributes which is to be implemented or is already implemented through a change order
`EGO_ITEMS_V`	This view provides item attributes used for UCCNet product synchronization
`EGO_ITEM_ATTRIBUTES_V`	View for getting the control levels of Item Attributes.
`EGO_ITEM_GTIN_V`	View for item gtin details
`EGO_ITEM_GTN_ATTRS_VL`	View for single row gtin attributes
`EGO_ITEM_ICV`	Item Classification View (ICV) for Items.
`EGO_ITEM_MAIN_ATTRS_V`	View for getting the Primary Item Attributes
`EGO_ITEM_MINOR_REVISIONS_V`	View for minor revisons information for any object.
`EGO_ITEM_OCV`	Object Classification View (OCV) for Item
`EGO_ITEM_STATUS_V`	This view is used for Item Status details.
`EGO_ITEM_SYNC_OP_V`	This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel OnPremise
`EGO_ITEM_SYNC_V`	This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel
`EGO_ITEM_TP_ATTRS_EXT_VL`	This view stores the Trading Partner specific attribute values for an Item. This table is used in UCCnet Industry extensions.
`EGO_ITMATTR_APPL_USGS_V`	View contains all the Attribute Groups enabled for an application.
`EGO_ITM_GTN_MUL_ATTRS_VL`	View for multi row gtin attributes
`EGO_MAPPINGS_V`	View contains the mapping data for attribute to parameter mapping of a function
`EGO_MTL_SY_ITEMS_CHG_VL`	This view stores the pending changes information for item operational attributes
`EGO_MTL_SY_ITEMS_EXT_VL`	VL View for Item User Defined Attributes
`EGO_OBJ_ATTR_GRP_ASSOCS_V`	View contains Attribute Group to Object Association
`EGO_PAGES_V`	View contains the User-Defined Pages
`EGO_PAGE_ENTRIES_V`	View contains the entries for User-Defined Pages
`EGO_PARTY_SITE_GLN_V`	This view contains Customers and their GLNs.
`EGO_PEOPLE_V`	This view contains the people information
`EGO_PERSON_COMPANY_V`	View contains Person to Company information
`EGO_PROD_CAT_SALES_MARKET_AGV`	This view is used to retrieve sales and marketing attribute group values for product catalog
`EGO_PUB_BATCH_STATUS_VL`
`EGO_PUB_BAT_ENT_OBJS_V`
`EGO_PUB_BAT_STATUS_V`
`EGO_PUB_PARAMETERS_V`
`EGO_PUB_WS_OUTPUT_V`
`EGO_REPORT_LISTS_VL`	This view is a multi-lingual view on the Report Lists tables
`EGO_RESULTS_FORMAT_COLUMNS_V`	This view stores all of the results columns associated with all of the results formats
`EGO_RESULTS_FORMAT_SECTIONS_V`	This view stores all of the results sections associated with all of the results formats
`EGO_RESULTS_FORMAT_V`	This is a view of all of the results formats
`EGO_ROLES_V`	View contains all the Roles defined
`EGO_ROLE_DETAILS_V`	View contains the Role Details
`EGO_ROLE_PRIVILEGES_V`	View contains all the privileges defined for Role
`EGO_RULE_SETS_VL`	this view contains the ruleset metadata
`EGO_STAT_ATTRIB_VALUES_V`	View for getting the status controlled attribute values for Item Attributes.
`EGO_SYS_ITEM_EXT_LANG_V`	View contains Item User-Defined Attribute Group data with langauge and Attribute group Type
`EGO_USER_RULES_VL`	this view contains the rule metadata
`EGO_USER_V`	View contains the user and party information
`EGO_VALIDATION_TABLE_INFO_V`	View contains information for Value Set for table type
`EGO_VALUE_SETS_V`	This view contains the value sets supported in EGO Application
`EGO_VALUE_SET_FORMAT_CODES_V`	View contains formay codes supported for Value Sets
`EGO_VALUE_SET_VALUES_V`	This view contains the value set values supported in EGO Application
`EGO_VAL_SET_VALUE_TABLES_V`
`EGO_VENDOR_COMPANY_V`	Vendor - Company View.
`EGO_VENDOR_PEOPLE_V`	View contains all the Vendor People.
`EGO_VENDOR_V`	This view is used to store the vendor ids against supplier contacts
`EGO_VS_DISPLAY_CODES_V`	This view contains the applicable display codes for Value Sets supported in EGO Application
`EGO_VS_FORMAT_CODES_V`	This view contains the applicable format codes for Value Sets supported in EGO Application
`EGO_VS_VALIDATION_CODES_V`	This view contains the applicable validation codes for Value Sets supported in EGO Application