eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - EGO Tables and Views

TABLE - EGO.EGO_ACTIONS_B
TABLE - EGO.EGO_ACTIONS_DL
TABLE - EGO.EGO_ACTIONS_TL
TABLE - EGO.EGO_ACTION_DISPLAYS_B
TABLE - EGO.EGO_ACTION_GROUPS_B
TABLE - EGO.EGO_ACTION_GROUPS_TL
TABLE - EGO.EGO_ACTN_GRP_ENTRIES_B
TABLE - EGO.EGO_AML_INTF
TABLE - EGO.EGO_ATTR_GROUP_DL
TABLE - EGO.EGO_ATTR_MAPPING_MASTER
TABLE - EGO.EGO_ATTR_MAPPING_ROWS
TABLE - EGO.EGO_BULKLOAD_INTF
TABLE - EGO.EGO_BUSINESS_EVENTS_TRACKING
TABLE - EGO.EGO_CATG_MAP_DTLS
TABLE - EGO.EGO_CATG_MAP_HDRS_B
TABLE - EGO.EGO_CATG_MAP_HDRS_TL
TABLE - EGO.EGO_CAT_GRP_MFG_ASSOCS
TABLE - EGO.EGO_CAT_GRP_RPT_TEMPLATES
TABLE - EGO.EGO_CAT_GRP_TEMPLATES
TABLE - EGO.EGO_CRITERIA_EXT
TABLE - EGO.EGO_CUSTOMIZATION_EXT
TABLE - EGO.EGO_CUSTOMIZATION_RF
TABLE - EGO.EGO_DATA_LEVEL_B
TABLE - EGO.EGO_DATA_LEVEL_TL
TABLE - EGO.EGO_DEFAULT_OPTIONS
TABLE - EGO.EGO_EXT_SYS_ELEMENTS
TABLE - EGO.EGO_FND_DESC_FLEXS_EXT
TABLE - EGO.EGO_FND_DF_COL_USGS_EXT
TABLE - EGO.EGO_FND_DSC_FLX_CTX_EXT
TABLE - EGO.EGO_FND_FLX_VAL_STS_EXT
TABLE - EGO.EGO_FND_OBJECTS_EXT
TABLE - EGO.EGO_FUNCTIONS_B
TABLE - EGO.EGO_FUNCTIONS_TL
TABLE - EGO.EGO_FUNC_PARAMS_B
TABLE - EGO.EGO_FUNC_PARAMS_TL
TABLE - EGO.EGO_GLOBAL_BUTTON
TABLE - EGO.EGO_GTIN_SETUP
TABLE - EGO.EGO_GTN_ATTR_CHG_B
TABLE - EGO.EGO_GTN_ATTR_CHG_TL
TABLE - EGO.EGO_GTN_MUL_ATTR_CHG_B
TABLE - EGO.EGO_GTN_MUL_ATTR_CHG_TL
TABLE - EGO.EGO_IMAGES
TABLE - EGO.EGO_IMPORT_BATCHES_B
TABLE - EGO.EGO_IMPORT_BATCHES_TL
TABLE - EGO.EGO_IMPORT_BATCH_CHANGES
TABLE - EGO.EGO_IMPORT_COPY_OPTIONS
TABLE - EGO.EGO_IMPORT_EXCLUDED_SS_ITEMS
TABLE - EGO.EGO_IMPORT_OPTION_SETS
TABLE - EGO.EGO_INBOUND_MSG_EXT
TABLE - EGO.EGO_INCLUDED_BUSINESSENTITIES
TABLE - EGO.EGO_INCLUDED_RULESETS
TABLE - EGO.EGO_INTERFACE_TL
TABLE - EGO.EGO_ITEMS_ATTRS_CHANGES_B
TABLE - EGO.EGO_ITEMS_ATTRS_CHANGES_TL
TABLE - EGO.EGO_ITEM_ASSOCIATIONS
TABLE - EGO.EGO_ITEM_ASSOCIATIONS_INTF
TABLE - EGO.EGO_ITEM_CAT_DENORM_HIER
TABLE - EGO.EGO_ITEM_CUST_ATTRS_B
TABLE - EGO.EGO_ITEM_GTN_ATTRS_B
TABLE - EGO.EGO_ITEM_GTN_ATTRS_TL
TABLE - EGO.EGO_ITEM_MATCHES
TABLE - EGO.EGO_ITEM_PEOPLE_INTF
TABLE - EGO.EGO_ITEM_PROJECTS
TABLE - EGO.EGO_ITEM_TEXT_TL
TABLE - EGO.EGO_ITEM_TP_ATTRS_EXT_B
TABLE - EGO.EGO_ITEM_TP_ATTRS_EXT_TL
TABLE - EGO.EGO_ITMATTR_APPL_USGS_B
TABLE - EGO.EGO_ITM_GTN_MUL_ATTRS_B
TABLE - EGO.EGO_ITM_GTN_MUL_ATTRS_TL
TABLE - EGO.EGO_ITM_USR_ATTR_INTRFC
TABLE - EGO.EGO_LANGUAGE_SETTINGS
TABLE - EGO.EGO_LCPHASE_ITEM_STATUS
TABLE - EGO.EGO_LCPHASE_POLICY
TABLE - EGO.EGO_LOGIN_ITEMS_TEMP
TABLE - EGO.EGO_MAPPINGS_B
TABLE - EGO.EGO_MASSUPDATE_ITEM_TMP
TABLE - EGO.EGO_MASSUPDATE_ORG_TMP
TABLE - EGO.EGO_MFG_PART_NUM_CHGS
TABLE - EGO.EGO_MINOR_REVISIONS
TABLE - EGO.EGO_MTL_SY_ITEMS_CHG_B
TABLE - EGO.EGO_MTL_SY_ITEMS_CHG_TL
TABLE - EGO.EGO_MTL_SY_ITEMS_EXT_B
TABLE - EGO.EGO_MTL_SY_ITEMS_EXT_TL
TABLE - EGO.EGO_MY_ITEMS
TABLE - EGO.EGO_OBJECT_EXT_TABLES_B
TABLE - EGO.EGO_OBJECT_ROLES
TABLE - EGO.EGO_OBJTYPE_ATTACH_CATS
TABLE - EGO.EGO_OBJ_AG_ASSOCS_B
TABLE - EGO.EGO_OBJ_ROLE_MAPPINGS
TABLE - EGO.EGO_OBJ_TYPE_LIFECYCLES
TABLE - EGO.EGO_PAGES_B
TABLE - EGO.EGO_PAGES_TL
TABLE - EGO.EGO_PAGE_ENTRIES_B
TABLE - EGO.EGO_PRODUCT_CAT_SET_EXT
TABLE - EGO.EGO_REPORTS
TABLE - EGO.EGO_REPORT_LISTS_B
TABLE - EGO.EGO_REPORT_LISTS_TL
TABLE - EGO.EGO_REPORT_LIST_ENTRIES
TABLE - EGO.EGO_RESULTS_FMT_USAGES
TABLE - EGO.EGO_RULE_ASSIGNMENTS
TABLE - EGO.EGO_RULE_ATTRIBUTE_USAGES
TABLE - EGO.EGO_RULE_SETS_B
TABLE - EGO.EGO_RULE_SETS_TL
TABLE - EGO.EGO_SKU_VARIANT_ATTR_USAGES
TABLE - EGO.EGO_SOURCE_SYSTEM_EXT
TABLE - EGO.EGO_STYLE_VARIANT_ATTR_VS
TABLE - EGO.EGO_SUBTAB
TABLE - EGO.EGO_SUPPLIERSITE_TMP
TABLE - EGO.EGO_TAB_SETUP
TABLE - EGO.EGO_TEMPL_ATTRIBUTES
TABLE - EGO.EGO_UCCNET_ADD_CIC_INFO
TABLE - EGO.EGO_UCCNET_BASELINES
TABLE - EGO.EGO_UCCNET_EVENTS
TABLE - EGO.EGO_UOM_MAPPING_MASTER
TABLE - EGO.EGO_UOM_MAPPING_ROWS
TABLE - EGO.EGO_USER_RULES_B
TABLE - EGO.EGO_USER_RULES_TL
TABLE - EGO.EGO_VALUE_SET_EXT
TABLE - EGO.EGO_VS_VALUES_DISP_ORDER
TABLE - EGO.EGO_XML_SCHEMA_DEFINITIONS
VIEW - APPS.EGO_ACTIONS_V
VIEW - APPS.EGO_ACTION_DISPLAYS_V
VIEW - APPS.EGO_ACTION_GROUPS_V
VIEW - APPS.EGO_ALL_ATTR_BASE_V
VIEW - APPS.EGO_ALL_ATTR_LANG_V
VIEW - APPS.EGO_ATTRS_V
VIEW - APPS.EGO_ATTR_GROUPS_DL_V
VIEW - APPS.EGO_ATTR_GROUPS_V
VIEW - APPS.EGO_ATTR_GROUP_OBJ_IDS_V
VIEW - APPS.EGO_ATTR_GROUP_TYPES_V
VIEW - APPS.EGO_ATTR_GROUP_TYPE_OBJ_IDS_V
VIEW - APPS.EGO_CATALOG_GROUPS_V
VIEW - APPS.EGO_CATG_MAP_HDRS_VL
VIEW - APPS.EGO_COMPANIES_V
VIEW - APPS.EGO_CRITERIA_TEMPLATES_V
VIEW - APPS.EGO_CRITERIA_V
VIEW - APPS.EGO_CUSTOMER_COMPANY_V
VIEW - APPS.EGO_CUSTOMER_PEOPLE_V
VIEW - APPS.EGO_DATA_LEVEL_VL
VIEW - APPS.EGO_FINANCIAL_REPORTING_AGV
VIEW - APPS.EGO_FND_OBJECTS_V
VIEW - APPS.EGO_FP_DATA_TYPES_V
VIEW - APPS.EGO_FUNCTIONS_V
VIEW - APPS.EGO_FUNC_PARAMS_V
VIEW - APPS.EGO_GROUPS_V
VIEW - APPS.EGO_GROUP_MEMBERS_V
VIEW - APPS.EGO_GTIN_ATTRS_TL_V
VIEW - APPS.EGO_GTIN_ATTRS_V
VIEW - APPS.EGO_GTIN_BARCODE_ATTRS_V
VIEW - APPS.EGO_GTIN_COLOR_ATTRS_V
VIEW - APPS.EGO_GTIN_COUNTRY_ORGN_V
VIEW - APPS.EGO_GTIN_DELIVERY_METHOD_V
VIEW - APPS.EGO_GTIN_HAND_INF_ATTRS_V
VIEW - APPS.EGO_GTIN_HARMONIZED_ID_V
VIEW - APPS.EGO_GTIN_HAZMAT_ATTRS_V
VIEW - APPS.EGO_GTIN_MFG_ATTRS_V
VIEW - APPS.EGO_GTIN_SIZE_DESC_V
VIEW - APPS.EGO_GTIN_TP_ATTRS_V
VIEW - APPS.EGO_GTIN_UCCNET_HIER_ATTRS_V
VIEW - APPS.EGO_GTN_ATTR_CHG_VL
VIEW - APPS.EGO_GTN_MUL_ATTR_CHG_VL
VIEW - APPS.EGO_IMPORT_BATCHES_VL
VIEW - APPS.EGO_IMPORT_BATCH_DETAILS_V
VIEW - APPS.EGO_INTERNAL_COMPANY_V
VIEW - APPS.EGO_INTERNAL_PEOPLE_V
VIEW - APPS.EGO_ITEMS_ATTRS_CHANGES_VL
VIEW - APPS.EGO_ITEMS_V
VIEW - APPS.EGO_ITEM_ATTRIBUTES_V
VIEW - APPS.EGO_ITEM_GTIN_V
VIEW - APPS.EGO_ITEM_GTN_ATTRS_VL
VIEW - APPS.EGO_ITEM_ICV
VIEW - APPS.EGO_ITEM_MAIN_ATTRS_V
VIEW - APPS.EGO_ITEM_MINOR_REVISIONS_V
VIEW - APPS.EGO_ITEM_OCV
VIEW - APPS.EGO_ITEM_STATUS_V
VIEW - APPS.EGO_ITEM_SYNC_OP_V
VIEW - APPS.EGO_ITEM_SYNC_V
VIEW - APPS.EGO_ITEM_TP_ATTRS_EXT_VL
VIEW - APPS.EGO_ITMATTR_APPL_USGS_V
VIEW - APPS.EGO_ITM_GTN_MUL_ATTRS_VL
VIEW - APPS.EGO_MAPPINGS_V
VIEW - APPS.EGO_MTL_SY_ITEMS_CHG_VL
VIEW - APPS.EGO_MTL_SY_ITEMS_EXT_VL
VIEW - APPS.EGO_OBJ_ATTR_GRP_ASSOCS_V
VIEW - APPS.EGO_PAGES_V
VIEW - APPS.EGO_PAGE_ENTRIES_V
VIEW - APPS.EGO_PARTY_SITE_GLN_V
VIEW - APPS.EGO_PEOPLE_V
VIEW - APPS.EGO_PERSON_COMPANY_V
VIEW - APPS.EGO_PROD_CAT_SALES_MARKET_AGV
VIEW - APPS.EGO_REPORT_LISTS_VL
VIEW - APPS.EGO_RESULTS_FORMAT_COLUMNS_V
VIEW - APPS.EGO_RESULTS_FORMAT_SECTIONS_V
VIEW - APPS.EGO_RESULTS_FORMAT_V
VIEW - APPS.EGO_ROLES_V
VIEW - APPS.EGO_ROLE_DETAILS_V
VIEW - APPS.EGO_ROLE_PRIVILEGES_V
VIEW - APPS.EGO_RULE_SETS_VL
VIEW - APPS.EGO_STAT_ATTRIB_VALUES_V
VIEW - APPS.EGO_SYS_ITEM_EXT_LANG_V
VIEW - APPS.EGO_USER_RULES_VL
VIEW - APPS.EGO_USER_V
VIEW - APPS.EGO_VALIDATION_TABLE_INFO_V
VIEW - APPS.EGO_VALUE_SETS_V
VIEW - APPS.EGO_VALUE_SET_FORMAT_CODES_V
VIEW - APPS.EGO_VALUE_SET_VALUES_V
VIEW - APPS.EGO_VAL_SET_VALUE_TABLES_V
VIEW - APPS.EGO_VENDOR_COMPANY_V
VIEW - APPS.EGO_VENDOR_PEOPLE_V
VIEW - APPS.EGO_VENDOR_V
VIEW - APPS.EGO_VS_DISPLAY_CODES_V
VIEW - APPS.EGO_VS_FORMAT_CODES_V
VIEW - APPS.EGO_VS_VALIDATION_CODES_V

Table: EGO_ACTIONS_B

Description:	This table contains information about User-Defined Actions.

Comments

Table EGO_ACTIONS_B stores the definition information required to create actions for attribute groups. The information includes the action name, attribute group for which the action was defined, sequence, function to execute and security privileges required to execute it among others.

Indexes

Index	Type	Tablespace	Column
EGO_ACTIONS_B_U1	UNIQUE	APPS_TS_TX_IDX	ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_ID	NUMBER		Y	Unique identifier for Action
OBJECT_ID	NUMBER		Y	Object Identifier
CLASSIFICATION_CODE	VARCHAR2	(150)		Classification Code for the objects. Example - Item Catalog Category
ATTR_GROUP_ID	NUMBER	(10)		Attribute group identifier to which this action is assigned to.
SEQUENCE	NUMBER		Y	It determines the order in which actions associated to a particular attribute group are shown while displaying the actions
ACTION_NAME	VARCHAR2	(60)	Y	Identifier of the Function that is initiated with this action
FUNCTION_ID	NUMBER		Y	Identifier of the Function that is assocaited with this action
SECURITY_PRIVILEGE_ID	NUMBER			Function Id (Privilege) associated with this action
CREATED_BY	NUMBER	(15)	Y	Standard WHO Column
CREATION_DATE	DATE		Y	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_DATE	DATE		Y	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
ENABLE_KEY_ATTRIBUTES	VARCHAR2	(1)		Flag to indicate whether to pass the Key Attributes to the function or not

Name	Datatype	Length	Mandatory	Comments
ACTION_ID	NUMBER		Y	The Action Id for which the Visibilty flag is enabled/disabled.
DATA_LEVEL_ID	NUMBER		Y	The datalevel Id for which the Visibilty flag is enabled/disabled for a given action Id
VISIBILITY_FLAG	VARCHAR2	(1)		The flag Y/N that will tell whether the action is enabled or disabled for a given data level Id
CREATED_BY	NUMBER		Y	One of the five standard "WHO" columns
CREATION_DATE	DATE		Y	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER		Y	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Y	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER			One of the five standard "WHO" columns

Name	Datatype	Length	Mandatory	Comments
ACTION_ID	NUMBER		Y	Unique identifier for Action (Foreign key for ACTION_ID in EGO_ACTIONS_B)
DESCRIPTION	VARCHAR2	(240)		Description of the Action
LANGUAGE	VARCHAR2	(4)	Y	Language in which description is stored
SOURCE_LANG	VARCHAR2	(4)	Y	Language in which the row was initially created
CREATED_BY	NUMBER	(15)	Y	Standard WHO Column
CREATION_DATE	DATE		Y	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_DATE	DATE		Y	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column

Name	Datatype	Length	Mandatory	Comments
ACTION_ID	NUMBER		Y	Unique identifier for Action.
EXECUTION_METHOD	VARCHAR2	(3)	Y	Defines if the Action execution is User based or trigger based.
EXECUTION_TRIGGER	VARCHAR2	(30)		Trigger to be initiated for action in case action is trigger based
DISPLAY_STYLE	VARCHAR2	(3)		Display style of this action either Button interface or Link interface
PROMPT_APPLICATION_ID	NUMBER			Application Identifier associated with this Action.
PROMPT_MESSAGE_NAME	VARCHAR2	(30)		Prompt that will be shown on User interface (Button or Link)
VISIBILITY_FLAG	VARCHAR2	(1)		Whether the Action is visible or not
PROMPT_FUNCTION_ID	NUMBER			Id of the function which will determine the prompt for the Action. Foreign key to EGO_FUNCTIONS_B
VISIBILITY_FUNC_ID	NUMBER			Id of the function which will determine whether the action would be visible or not
CREATED_BY	NUMBER	(15)	Y	Standard WHO Column
CREATION_DATE	DATE		Y	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_DATE	DATE		Y	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column

Index	Type	Tablespace	Column
EGO_ACTION_GROUPS_B_U1	UNIQUE	APPS_TS_TX_IDX	ACTION_GROUP_ID
EGO_ACTION_GROUPS_B_U2	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID CLASSIFICATION_CODE SEQUENCE

Name	Datatype	Length	Mandatory	Comments
ACTION_GROUP_ID	NUMBER		Y	Unique identifier for Action group
OBJECT_ID	NUMBER		Y	Object Identifier
CLASSIFICATION_CODE	VARCHAR2	(150)		Classification Code for the objects. Example - Item Catalog Group ID
SEQUENCE	NUMBER		Y	Sequence of the action group
INTERNAL_NAME	VARCHAR2	(60)	Y	Action group internal name
CREATED_BY	NUMBER	(15)	Y	Attribute group internal name
CREATION_DATE	DATE		Y	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_DATE	DATE		Y	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column

Index	Type	Tablespace	Column
EGO_ACTN_GRP_ENTRIES_B_U1	UNIQUE	APPS_TS_TX_IDX	ACTION_GROUP_ID ACTION_ID
EGO_ACTN_GRP_ENTRIES_B_U2	UNIQUE	APPS_TS_TX_IDX	ACTION_GROUP_ID SEQUENCE

Index	Type	Tablespace	Column
EGO_AML_INTF_U1	UNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
EGO_AML_INTF_N1	NONUNIQUE	APPS_TS_INTERFACE	DATA_SET_ID

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)		Refers to the concurrent request id
DATA_SET_ID	NUMBER	(15)	Y	Refers to the data set that need to be processed
TRANSACTION_ID	NUMBER	(15)		Unique key to identify records in this table
PROCESS_FLAG	NUMBER	(15)		Indicates the status of the record
TRANSACTION_TYPE	VARCHAR2	(15)	Y	Indicates the action user wants to perform on the Production Data
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory item identifier.Foreign key to MTL_SYSTEM_ITEMS_B
ITEM_NUMBER	VARCHAR2	(240)		Refers to concatenated_segments from MTL_SYSTEM_ITEMS_B_KFV
ORGANIZATION_ID	NUMBER	(15)		Organization identifier.Foreign key to MTL_PARAMTERES
ORGANIZATION_CODE	VARCHAR2	(3)		Refers to organization_code from MTL_PARAMETERS
MANUFACTURER_ID	NUMBER	(15)		Manufacturer identifier.Foreign key to MTL_MANUFACTURERS
MANUFACTURER_NAME	VARCHAR2	(30)		Refers to manufacturer_name from MTL_MANUFACTURERS
MFG_PART_NUM	VARCHAR2	(150)		Manufacturer Part Number
MRP_PLANNING_CODE	NUMBER	(15)		MRP Planning Code
DESCRIPTION	VARCHAR2	(240)		Description of the Manufacturer Part Number
START_DATE	DATE			Effective start date of the manufacturer part number
END_DATE	DATE			Effective end date of the manufacturer part number
FIRST_ARTICLE_STATUS	VARCHAR2	(30)		Refers to information about the First Article Status
FIRST_ARTICLE_STATUS_MEANING	VARCHAR2	(80)		First Article Status meaning as seen in fnd_lookup_values
APPROVAL_STATUS	VARCHAR2	(30)		Refers to information about the Approval Status
APPROVAL_STATUS_MEANING	VARCHAR2	(80)		Approval Status meaning as seen in fnd_lookup_values
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		DFF Standard field - Attribute Category
ATTRIBUTE1	VARCHAR2	(150)		DFF Standard field - Attribute1
ATTRIBUTE2	VARCHAR2	(150)		DFF Standard field - Attribute2
ATTRIBUTE3	VARCHAR2	(150)		DFF Standard field - Attribute3
ATTRIBUTE4	VARCHAR2	(150)		DFF Standard field - Attribute4
ATTRIBUTE5	VARCHAR2	(150)		DFF Standard field - Attribute5
ATTRIBUTE6	VARCHAR2	(150)		DFF Standard field - Attribute6
ATTRIBUTE7	VARCHAR2	(150)		DFF Standard field - Attribute7
ATTRIBUTE8	VARCHAR2	(150)		DFF Standard field - Attribute8
ATTRIBUTE9	VARCHAR2	(150)		DFF Standard field - Attribute9
ATTRIBUTE10	VARCHAR2	(150)		DFF Standard field - Attribute10
ATTRIBUTE11	VARCHAR2	(150)		DFF Standard field - Attribute11
ATTRIBUTE12	VARCHAR2	(150)		DFF Standard field - Attribute12
ATTRIBUTE13	VARCHAR2	(150)		DFF Standard field - Attribute13
ATTRIBUTE14	VARCHAR2	(150)		DFF Standard field - Attribute14
ATTRIBUTE15	VARCHAR2	(150)		DFF Standard field - Attribute15
CREATED_BY	NUMBER	(15)		One of the five standard "WHO" columns
CREATION_DATE	DATE			One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)		One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE			One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)		One of the five standard "WHO" columns
PROGRAM_APPLICATION_ID	NUMBER	(15)		Used as a standard to replicate all columns from the production table
PROGRAM_ID	NUMBER	(15)		Used as a standard to replicate all columns from the production table
PROGRAM_UPDATE_DATE	DATE			Used as a standard to replicate all columns from the production table
PROG_INT_NUM1	NUMBER	(15)		Internal column used by the bulkload program. Not for user entry
PROG_INT_NUM2	NUMBER	(15)		Internal column used by the bulkload program. Not for user entry
PROG_INT_NUM3	NUMBER	(15)		Internal column used by the bulkload program. Not for user entry
PROG_INT_NUM4	NUMBER	(15)		Internal column used by the bulkload program. Not for user entry
PROG_INT_CHAR1	VARCHAR2	(255)		Internal column used by the bulkload program. Not for user entry
PROG_INT_CHAR2	VARCHAR2	(2000)		Internal column used by the bulkload program. Not for user entry
CHANGE_ID	NUMBER	(15)		Used to store the change to which the record is associated
CHANGE_LINE_ID	NUMBER	(15)		Used to store the change line to which the record is associated
SOURCE_SYSTEM_ID	NUMBER	(37)		Source System Identifier
SOURCE_SYSTEM_REFERENCE	VARCHAR2	(255)		Source System Reference
SOURCE_SYSTEM_REFERENCE_DESC	VARCHAR2	(240)		Source System Reference Description

Name	Datatype	Length	Mandatory	Comments
ATTR_GROUP_ID	NUMBER		Y	Attribute Group Identifier, Foreign key to EGO_FND_DSC_FLX_CTX_EXT.ATTR_GROUP_ID
DATA_LEVEL_ID	NUMBER		Y	Data Level Identifier, Foreign key to EGO_DATA_LEVEL_B.DATA_LEVEL_ID.
DEFAULTING	VARCHAR2	(30)		Indicates the behavior of the Data Level across Style and SKU Items.
VIEW_PRIVILEGE_ID	NUMBER			View Privilege Identifier, Foreign key to FND_FORM_FUNCTIONS.FUNCTION_ID
EDIT_PRIVILEGE_ID	NUMBER			Edit Privilege Identifier, Foreign key to FND_FORM_FUNCTIONS.FUNCTION_ID
RAISE_PRE_EVENT	VARCHAR2	(1)		Flag Y/N indicates trigger of Pre Event at the data level.
RAISE_POST_EVENT	VARCHAR2	(1)		Flag Y/N indicates trigger of Post Event at the data level.
CREATED_BY	NUMBER		Y	One of the five standard "WHO" columns
CREATION_DATE	DATE		Y	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER		Y	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Y	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER			One of the five standard "WHO" columns

Index	Type	Tablespace	Column
EGO_ATTR_MAPPING_MASTER_U1	UNIQUE	APPS_TS_TX_IDX	ATTR_MAPPING_ID
SYS_IL0000396713C00011$$	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000396713C00012$$	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000396713C00013$$	UNIQUE	APPS_TS_TX_DATA

Name	Datatype	Length	Mandatory	Comments
RESULTFMT_USAGE_ID	NUMBER	(15)	Y	Unique usage identifier for the Result Format
TRANSACTION_TYPE	VARCHAR2	(10)	Y	Type of transaction. Valid values are: CREATE, UPDATE.
TRANSACTION_ID	NUMBER	(15)		Unique identifier for the line. It is suggested to retrieve the value for this from corresponding Entity Interface table sequences. E.g., for Item related lines, the sequence suggested is MTL_SYSTEM_ITEMS_INTERFACE_S for the Transaction ID.
PROCESS_STATUS	NUMBER	(15)		Indicates the status of the line. Valid numeric values should indicate statuses: To be processed, In Process, Error, Success.
INSTANCE_PK1_VALUE	VARCHAR2	(256)		Primary Key Column 1
INSTANCE_PK2_VALUE	VARCHAR2	(256)		Primary Key Column 2
INSTANCE_PK3_VALUE	VARCHAR2	(256)		Primary Key Column 3
INSTANCE_PK4_VALUE	VARCHAR2	(256)		Primary Key Column 4
INSTANCE_PK5_VALUE	VARCHAR2	(256)		Primary Key Column 5
CREATED_BY	NUMBER	(15)		One of the five standard "WHO" columns
CREATION_DATE	DATE			One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)		One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE			One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)		One of the five standard "WHO" columns
REQUEST_ID	NUMBER	(15)		Concurrent Program Submission Request ID
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program Application ID
PROGRAM_ID	NUMBER	(15)		Concurrent Program ID
PROGRAM_UPDATE_DATE	DATE			Concurrent Program update date. When the concurrent program finishes processing this line, the SYSDATE at that time can be set to this column.
C_INTF_ATTR1	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR2	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR3	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR4	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR5	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR6	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR7	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR8	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR9	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR10	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR11	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR12	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR13	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR14	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR15	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR16	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR17	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR18	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR19	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR20	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR21	VARCHAR2	(1000)		Character Attribute Value Column.
C_INTF_ATTR22	VARCHAR2	(1000)		Character Attribute Value Column.

Name	Datatype	Length	Mandatory	Comments
ATTR_MAPPING_ID	NUMBER		Y	Unique identifier for each mapping row.
ATTR_MAPPING_NAME	VARCHAR2	(50)	Y	Name of Attribute Mapping
ATTR_MAPPING_DESCRIPTION	VARCHAR2	(150)		Description of the Attribute Mapping
SOURCE_SYSTEM_ID	NUMBER		Y	Foreign key to HZ_ORIG_SYSTEMS_VL
LAST_UPDATE_DATE	DATE		Y	Date record was last modified
LAST_UPDATED_BY	NUMBER		Y	User id of last person modifying the record
CREATION_DATE	DATE		Y	Date record was created
CREATED_BY	NUMBER		Y	User id of Person who created record
LAST_UPDATE_LOGIN	NUMBER			Login of last person who updated record
MAPPING_PROCESS	NUMBER		Y	Field to indicate which mapping process to follow
PDH_TRANSFORMATION_XSLT	CLOB	(4000)		XSLT formed based on the mapping
EXTERNAL_SYSTEM_XSD	CLOB	(4000)		External XSD of the External System
PDH_EXTERNAL_XSLT	CLOB	(4000)		External XSLT used in PDH for Transformation

Index	Type	Tablespace	Column
EGO_ATTR_MAPPING_ROWS_U1	UNIQUE	APPS_TS_TX_IDX	ATTR_MAPPING_ROW_ID
EGO_ATTR_MAPPING_ROWS_N1	NONUNIQUE	APPS_TS_TX_IDX	ATTR_MAPPING_ID

Name	Datatype	Length	Mandatory	Comments
ATTR_MAPPING_ROW_ID	NUMBER		Y	Unique identifier for each attr mapping row.
ATTR_MAPPING_ID	NUMBER		Y	Foreign key to EGO_ATTR_MAPPING_MASTER table.
ATTR_GROUP_ID	NUMBER		Y	Attribute Group Id
ATTR_ID	NUMBER		Y	Attribute Id
PK1_VALUE	VARCHAR2	(256)		PK Value to uniquely identify the Source System Attribute
PK2_VALUE	VARCHAR2	(256)		PK Value to uniquely identify the Source System Attribute
PK3_VALUE	VARCHAR2	(256)		PK Value to uniquely identify the Source System Attribute
PK4_VALUE	VARCHAR2	(256)		PK Value to uniquely identify the Source System Attribute
PK5_VALUE	VARCHAR2	(256)		PK Value to uniquely identify the Source System Attribute
LAST_UPDATE_DATE	DATE		Y	Date record was last modified
LAST_UPDATED_BY	NUMBER		Y	User id of last person modifying the record
CREATION_DATE	DATE		Y	Date record was created
CREATED_BY	NUMBER		Y	User id of Person who created record
LAST_UPDATE_LOGIN	NUMBER			Login of last person who updated record
DEFAULT_UOM	VARCHAR2	(50)		Default UOM of the Attribute
EXT_ATTR_DATA_TYPE	VARCHAR2	(10)		Data Type of the External Attribute
ATTRIBUTE_NAME	VARCHAR2	(256)		The PDH Attribute Internal Name
SOURCE_ATTRIBUTE_NAME	VARCHAR2	(256)		The Source System Attribute Name

Index	Type	Tablespace	Column
EGO_BUS_EVTS_TRKG_U1	UNIQUE	APPS_TS_TX_IDX	SEQUENCE_ID
SYS_IL0000455376C00009$$	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000455376C00012$$	UNIQUE	APPS_TS_TX_DATA

Name	Datatype	Length	Mandatory	Comments
SEQUENCE_ID	NUMBER		Y	Sequence Id
INVOKE_DATE	DATE		Y	Invocation Date
BUSINESS_EVENT_NAME	VARCHAR2	(4000)	Y	Business Event Name
EVENT_PAYLOAD	WF_EVENT_T	(1)	Y	Event Payload
INVENTORY_ITEM_ID	NUMBER			Inventory Item Id
ORGANIZATION_ID	NUMBER			Organization Id
CATALOG_ID	NUMBER			Catalog Id
CATEGORY_ID	NUMBER			Category Id

Name	Datatype	Length	Mandatory	Comments
CATG_MAP_ID	NUMBER	(15)	Y	Identifier for the Category Mapping Set
SOURCE_CATG_ID	NUMBER	(15)	Y	Identifier for the Source Category
TARGET_CATG_ID	NUMBER	(15)	Y	Identifier for the Target Category
CREATED_BY	NUMBER	(15)	Y	One of the five standard "WHO" columns
CREATION_DATE	DATE		Y	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)	Y	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Y	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)		One of the five standard "WHO" columns

Index	Type	Tablespace	Column
EGO_CATG_MAP_HDRS_B_U1	UNIQUE	APPS_TS_TX_IDX	CATG_MAP_ID
EGO_CATG_MAP_HDRS_B_U2	UNIQUE	APPS_TS_TX_IDX	SOURCE_CATG_SET_ID TARGET_CATG_SET_ID

Name	Datatype	Length	Mandatory	Comments
CATALOG_GROUP_ID	NUMBER	(15)	Y	Item catalog group identifier.Foreign key to MTL_ITEM_CATALOG_GROUPS_B
MANUFACTURER_ID	NUMBER	(15)	Y	Manufacturer identifier.Foreign key to MTL_MANUFACTURERS
CREATED_BY	NUMBER	(15)	Y	Standard WHO Column
CREATION_DATE	DATE		Y	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_DATE	DATE		Y	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
PREFERENCE_LEVEL	VARCHAR2	(30)		Preference Level for a Catalog Group - Manufacturer

Name	Datatype	Length	Mandatory	Comments
CATALOG_GROUP_ID	NUMBER	(22)	Y	Item catalog group identifier.Foreign key to MTL_ITEM_CATALOG_GROUPS_B
TEMPLATE_ID	NUMBER	(22)	Y	Foreign key to XDO_TEMPLATES_B.TEMPLATE_ID
CREATION_DATE	DATE		Y	Standard WHO Column
CREATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_DATE	DATE		Y	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column

Name	Datatype	Length	Mandatory	Comments
CATALOG_GROUP_ID	NUMBER		Y	Catalog group identifier
TEMPLATE_ID	NUMBER		Y	Template Id
CREATED_BY	NUMBER	(15)	Y	Standard WHO Column
CREATION_DATE	DATE		Y	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_DATE	DATE		Y	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
DEFAULT_FLAG	VARCHAR2	(1)		Specifies if this association is default for catalog category

Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

eTRM - EGO Tables and Views

Table: EGO_ACTIONS_B

Comments

Indexes

Columns

Table: EGO_ACTIONS_DL

Comments

Indexes

Columns

Table: EGO_ACTIONS_TL

Comments

Indexes

Columns

Table: EGO_ACTION_DISPLAYS_B

Comments

Indexes

Columns

Table: EGO_ACTION_GROUPS_B

Comments

Indexes

Columns

Table: EGO_ACTION_GROUPS_TL

Comments

Indexes

Columns

Table: EGO_ACTN_GRP_ENTRIES_B

Comments

Indexes

Columns

Table: EGO_AML_INTF

Comments

Indexes

Columns

Table: EGO_ATTR_GROUP_DL

Comments

Indexes

Columns

Table: EGO_ATTR_MAPPING_MASTER

Comments

Indexes

Columns

Table: EGO_ATTR_MAPPING_ROWS

Comments

Indexes

Columns

Table: EGO_BULKLOAD_INTF

Comments

Indexes

Columns

Table: EGO_BUSINESS_EVENTS_TRACKING

Comments

Indexes

Columns

Table: EGO_CATG_MAP_DTLS

Comments

Indexes

Columns

Table: EGO_CATG_MAP_HDRS_B

Comments

Indexes

Columns

Table: EGO_CATG_MAP_HDRS_TL

Comments

Indexes

Columns

Table: EGO_CAT_GRP_MFG_ASSOCS

Comments

Indexes

Columns

Table: EGO_CAT_GRP_RPT_TEMPLATES

Comments

Indexes

Columns

Table: EGO_CAT_GRP_TEMPLATES

Comments

Indexes

Columns

Table: EGO_CRITERIA_EXT

Name	Datatype	Length	Comments
CUSTOMIZATION_APPLICATION_ID	NUMBER	(15)	The Application ID of the Product Team using the Customization. Foreign Key from the AK_CRITERIA Table
CUSTOMIZATION_CODE	VARCHAR2	(30)	The Unique ID that identifies the Customization. Foreign Key from the AK_CRITERIA Table
REGION_APPLICATION_ID	NUMBER	(15)	The Application ID of the Product Team using the Customization. Foreign Key from the AK_CRITERIA Table
REGION_CODE	VARCHAR2	(30)	The Common Region Code that is used for each kind of Customization. Foreign Key from the AK_CRITERIA Table
ATTRIBUTE_APPLICATION_ID	NUMBER	(15)	The Application ID of the Attribute included as a Criterion in the Customization. Foreign Key from the AK_CRITERIA Table
ATTRIBUTE_CODE	VARCHAR2	(30)	The Unique Attribute code of the Attribute included as a Criterion in the Customization. Foreign Key from the AK_CRITERIA Table
SEQUENCE_NUMBER	NUMBER	(15)	The Sequence in which the Attributes appear in the Customization. Foreign Key from the AK_CRITERIA Table
USE_KEYWORD_SEARCH	VARCHAR2	(30)	The Sequence in which the Attributes appear in the Customization
MATCH_CONDITION	VARCHAR2	(30)	The Sequence in which the Attributes appear in the Customization
FUZZY	VARCHAR2	(1)	Indicates whether to apply Fuzzy logic for values specified for attributes while searching for entities
STEMMING	VARCHAR2	(1)	Indicates whether to apply Stemming logic for values specified for attributes while searching for entities
SYNONYMS	VARCHAR2	(1)	Indicates whether to apply Synonyms logic for values specified for attributes while searching for entities
CREATED_BY	NUMBER	(15)	One of the five standard "WHO" columns
CREATION_DATE	DATE		One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)	One of the five standard "WHO" columns
LAST_UPDATED_DATE	DATE		One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)	One of the five standard "WHO" columns

Index	Type	Tablespace	Column
EGO_CUSTOMIZATION_EXT_U1	UNIQUE	APPS_TS_TX_IDX	CUSTOMIZATION_APPLICATION_ID CUSTOMIZATION_CODE REGION_APPLICATION_ID REGION_CODE
EGO_CUSTOMIZATION_EXT_N1	NONUNIQUE	APPS_TS_TX_IDX	RF_CUSTOMIZATION_CODE

Name	Datatype	Length	Mandatory	Comments
DATA_LEVEL_ID	NUMBER		Y	Unique identifier for each data level row
APPLICATION_ID	NUMBER		Y	Refers to the ID of the application for which the data level applies.
ATTR_GROUP_TYPE	VARCHAR2	(40)	Y	Refers to the attribute group type for which the data level applies (EGO_ITEMMGMT_GROUP, EGO_ITEM_GTIN_ATTRS, BOM_COMPONENTMGMT_GROUP, etc)
DATA_LEVEL_NAME	VARCHAR2	(30)	Y	This is the name of the data level (e.g. ITEM_LEVEL, ITEM_ORG, COMPONENTS_LEVEL, etc)
PK1_COLUMN_NAME	VARCHAR2	(30)		This is the name of the primary key column one (PK1) for the data level
PK1_COLUMN_TYPE	VARCHAR2	(30)		This is the data type of the primary key column one (PK1) for the data level (e.g. NUMBER, VARCHAR, ETC.)
PK2_COLUMN_NAME	VARCHAR2	(30)		This is the name of the primary key column two (PK2) for the data level
PK2_COLUMN_TYPE	VARCHAR2	(30)		This is the data type of the primary key column two (PK2) for the data level (e.g. NUMBER, VARCHAR, ETC.)
PK3_COLUMN_NAME	VARCHAR2	(30)		This is the name of the primary key column three (PK3) for the data level
PK3_COLUMN_TYPE	VARCHAR2	(30)		This is the data type of the primary key column three (PK3) for the data level (e.g. NUMBER, VARCHAR, ETC.)
PK4_COLUMN_NAME	VARCHAR2	(30)		This is the name of the primary key column four (PK4) for the data level
PK4_COLUMN_TYPE	VARCHAR2	(30)		This is the data type of the primary key column four (PK4) for the data level (e.g. NUMBER, VARCHAR, ETC.)
PK5_COLUMN_NAME	VARCHAR2	(30)		This is the name of the primary key column five (PK5) for the data level
PK5_COLUMN_TYPE	VARCHAR2	(30)		This is the data type of the primary key column five (PK5) for the data level (e.g. NUMBER, VARCHAR, ETC.)
ENABLE_DEFAULTING	VARCHAR2	(1)		This is a flag that indicates if the defaulting option is enabled or not.
ENABLE_VIEW_PRIV	VARCHAR2	(1)		This is the priviledge required to view the data level
ENABLE_EDIT_PRIV	VARCHAR2	(1)		This is the priviledge required to edit the data level
ENABLE_PRE_EVENT	VARCHAR2	(1)		This is a flag that indicates if a business pre event needs to be raised
ENABLE_POST_EVENT	VARCHAR2	(1)		This is a flag that indicates if a business post event needs to be raised
CREATED_BY	NUMBER		Y	One of the five standard "WHO" columns
CREATION_DATE	DATE		Y	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER		Y	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Y	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER			One of the five standard "WHO" columns

Name	Datatype	Length	Mandatory	Comments
OPTION_CODE	VARCHAR2	(50)		Unique identifier for an option. The OPTION_CODE serves as the key in retrieving stored value.
OPTION_VALUE	VARCHAR2	(30)		The current value for an option, this can be updated for changing the system behaviour.
DESCRIPTION	VARCHAR2	(150)		Gives a brief description about where this value will be used.
CREATION_DATE	DATE		Y	Standard WHO Column
CREATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_DATE	DATE		Y	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column

Name	Datatype	Length	Mandatory	Comments
EXTERNAL_ELEMENT_ID	NUMBER		Y	Unique identifier for each Schema
SOURCE_SYSTEM_ID	NUMBER		Y	Foreign key to HZ_ORIG_SYSTEMS_VL
ELEMENT_TYPE	VARCHAR2	(1)	Y	To Determine if the element is an Attribute or an UOM.
EXT_ATTRIBUTE_NAME	VARCHAR2	(50)		Contains the External System Attribute Name.
EXT_UOM_NAME	VARCHAR2	(50)		Contains the External System UOM Name.
DEFAULT_UOM	VARCHAR2	(50)		Contains the default UOM for the given Attribute.
LAST_UPDATE_DATE	DATE		Y	Date record was last modified
LAST_UPDATED_BY	NUMBER		Y	User id of last person modifying the record
CREATION_DATE	DATE		Y	Date record was created
CREATED_BY	NUMBER		Y	User id of Person who created record
LAST_UPDATE_LOGIN	NUMBER			Login of last person who updated record
EXT_ATTR_DATA_TYPE	VARCHAR2	(10)		Datatype of External Attribute.

Index	Type	Tablespace	Column
EGO_FND_DF_COL_USGS_EXT_U1	UNIQUE	APPS_TS_TX_IDX	ATTR_ID
EGO_FND_DF_COL_USGS_EXT_U2	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEX_CONTEXT_CODE APPLICATION_COLUMN_NAME

Index	Type	Tablespace	Column
EGO_FND_DSC_FLX_CTX_EXT_U1	UNIQUE	APPS_TS_TX_IDX	ATTR_GROUP_ID
EGO_FND_DSC_FLX_CTX_EXT_U2	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEX_CONTEXT_CODE

Name	Datatype	Length	Mandatory	Comments
FLEX_VALUE_SET_ID	NUMBER	(10)	Y	Identifier for the Value Set (foreign key to FND_FLEX_VALUE_SETS)
CREATED_PROCESS	VARCHAR2	(30)	Y	Not currently used (records who created the Value Set, but all current entries are created by PLM)
LAST_UPDATE_PROCESS	VARCHAR2	(30)		Not currently used (records who last updated the Value Set, but all current entries are updated by PLM)
CREATED_BY	NUMBER	(15)	Y	One of the five standard "WHO" columns
CREATION_DATE	DATE		Y	One of the five standard "WHO" columns
LAST_UPDATED_BY	NUMBER	(15)	Y	One of the five standard "WHO" columns
LAST_UPDATE_DATE	DATE		Y	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	NUMBER	(15)		One of the five standard "WHO" columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_NAME	VARCHAR2	(430)	Y	Object Name from FND_OBJECTS
VIEW_PRIVILEGE	VARCHAR2	(480)		Name of the Data Security privilege necessary to view instances of the Object (foreign key to FND_FORM_FUNCTIONS)
NAME_DESC_SELECT_SQL	VARCHAR2	(1000)		SQL that will select a relevant description of the Object
PARENT_OBJECT_ID	NUMBER	(15)		Optional identifier for the parent object to this object, if there is one (foreign key to FND_OBJECTS)
EXT_ATTR_OCV_NAME	VARCHAR2	(30)		View name that provides the classification code and meaning
EXT_ATTR_ICV_NAME	VARCHAR2	(30)		View name that provides the instance PK values and the instance name
CLASSIFICATION_COL_NAME	VARCHAR2	(30)		The name of the classification column for the object
CLASSIFICATION_COL_TYPE	VARCHAR2	(30)		The type of the classification column for the object
CREATED_BY	NUMBER	(15)	Y	Standard WHO Column
CREATION_DATE	DATE		Y	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Y	Standard WHO Column
LAST_UPDATE_DATE	DATE		Y	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column

Index	Type	Tablespace	Column
EGO_FUNCTIONS_B_U1	UNIQUE	APPS_TS_TX_IDX	FUNCTION_ID
EGO_FUNCTIONS_B_U2	UNIQUE	APPS_TS_TX_IDX	INTERNAL_NAME