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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: EGO.EGO_IMPORT_OPTION_SETS

Object Details

Object Name:	EGO_IMPORT_OPTION_SETS
Object Type:	TABLE
Owner:	EGO
FND Design Data:	EGO.EGO_IMPORT_OPTION_SETS
Subobject Name:
Status:	VALID

This table stores default options for a source system or an import batch

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EGO_IMPORT_OPTION_SETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OPTION_SET_ID
EGO_IMPORT_OPTION_SETS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID
EGO_IMPORT_OPTION_SETS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_SYSTEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OPTION_SET_ID	NUMBER		Yes	Id of the option set
SOURCE_SYSTEM_ID	NUMBER			Source System code if for source systems level defaults.
BATCH_ID	NUMBER			Batch id if for batch level defaults
APPLY_DEF_MATCH_RULE_ALL	VARCHAR2	(1)		Apply the default match rule to all records from this source system
MATCH_ON_DATA_LOAD	VARCHAR2	(1)		Automatically match on data load
CONFIRM_SINGLE_MATCH	VARCHAR2	(1)		Automatically confirm single matches.
IMPORT_ON_DATA_LOAD	VARCHAR2	(1)		Automatically import on data load
REVISION_IMPORT_POLICY	VARCHAR2	(30)		Revision import policy, e.g. L for update latest, or N for create new.
IMPORT_XREF_ONLY	VARCHAR2	(1)		Import cross reference only
STRUCTURE_TYPE_ID	NUMBER			Id of the structure type
STRUCTURE_NAME	VARCHAR2	(10)		Internal code of the structure name
STRUCTURE_EFFECTIVITY_TYPE	NUMBER			Effectivity control type of the structure
EFFECTIVITY_DATE	DATE			Effectivity date
FROM_END_ITEM_UNIT_NUMBER	VARCHAR2	(30)		Overloaded column to store information for serial number or unit effectivity
STRUCTURE_CONTENT	VARCHAR2	(30)		Structure contains changed components only
CHANGE_ORDER_CREATION	VARCHAR2	(30)		Create new change order or add to existing change order.
ADD_ALL_TO_CHANGE_FLAG	VARCHAR2	(1)		Add all imported items to change order
CHANGE_MGMT_TYPE_CODE	VARCHAR2	(30)		Change Management Type Code
CHANGE_TYPE_ID	NUMBER			Change order type
CHANGE_NOTICE	VARCHAR2	(10)		Change order number
CHANGE_NAME	VARCHAR2	(240)		Change order name
CHANGE_DESCRIPTION	VARCHAR2	(2000)		Change order description
OBJECT_VERSION_NUMBER	NUMBER		Yes	Version number for concurrency control purpose.
CREATED_BY	NUMBER		Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column
DEF_MATCH_RULE_CUST_APP_ID	NUMBER			Default Match Rule Information
DEF_MATCH_RULE_CUST_CODE	VARCHAR2	(30)		Default Match Rule Information
DEF_MATCH_RULE_RN_APP_ID	NUMBER			Default Match Rule Information
DEF_MATCH_RULE_RN_CODE	VARCHAR2	(30)		Default Match Rule Information
NIR_OPTION	VARCHAR2	(1)		This column stores the New Item Request creation option. Valid values are N (None), C (One per item catalog category), I (One per Item).
ENABLED_FOR_DATA_POOL	VARCHAR2	(1)		This column stores whether batch/source system is enabled for Data Pool or not. If a batch is enabled for data pool, then only it can be used for inbound messages.
CONFIRM_NO_MATCH	VARCHAR2	(1)		Automatically Confirm New Item on No Match

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OPTION_SET_ID
,      SOURCE_SYSTEM_ID
,      BATCH_ID
,      APPLY_DEF_MATCH_RULE_ALL
,      MATCH_ON_DATA_LOAD
,      CONFIRM_SINGLE_MATCH
,      IMPORT_ON_DATA_LOAD
,      REVISION_IMPORT_POLICY
,      IMPORT_XREF_ONLY
,      STRUCTURE_TYPE_ID
,      STRUCTURE_NAME
,      STRUCTURE_EFFECTIVITY_TYPE
,      EFFECTIVITY_DATE
,      FROM_END_ITEM_UNIT_NUMBER
,      STRUCTURE_CONTENT
,      CHANGE_ORDER_CREATION
,      ADD_ALL_TO_CHANGE_FLAG
,      CHANGE_MGMT_TYPE_CODE
,      CHANGE_TYPE_ID
,      CHANGE_NOTICE
,      CHANGE_NAME
,      CHANGE_DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEF_MATCH_RULE_CUST_APP_ID
,      DEF_MATCH_RULE_CUST_CODE
,      DEF_MATCH_RULE_RN_APP_ID
,      DEF_MATCH_RULE_RN_CODE
,      NIR_OPTION
,      ENABLED_FOR_DATA_POOL
,      CONFIRM_NO_MATCH
FROM EGO.EGO_IMPORT_OPTION_SETS;

Dependencies

[top of page]

EGO.EGO_IMPORT_OPTION_SETS does not reference any database object

EGO.EGO_IMPORT_OPTION_SETS is referenced by following:

EGO: EGO_IMPORT_OPTION_SETS#