[Home] [Help] [Dependency Information]
Object Name: | EGO_IMPORT_OPTION_SETS# |
---|---|
Object Type: | VIEW |
Owner: | EGO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPTION_SET_ID | NUMBER | Yes | ||
SOURCE_SYSTEM_ID | NUMBER | |||
BATCH_ID | NUMBER | |||
APPLY_DEF_MATCH_RULE_ALL | VARCHAR2 | (1) | ||
MATCH_ON_DATA_LOAD | VARCHAR2 | (1) | ||
CONFIRM_SINGLE_MATCH | VARCHAR2 | (1) | ||
IMPORT_ON_DATA_LOAD | VARCHAR2 | (1) | ||
REVISION_IMPORT_POLICY | VARCHAR2 | (30) | ||
IMPORT_XREF_ONLY | VARCHAR2 | (1) | ||
STRUCTURE_TYPE_ID | NUMBER | |||
STRUCTURE_NAME | VARCHAR2 | (10) | ||
STRUCTURE_EFFECTIVITY_TYPE | NUMBER | |||
EFFECTIVITY_DATE | DATE | |||
FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
STRUCTURE_CONTENT | VARCHAR2 | (30) | ||
CHANGE_ORDER_CREATION | VARCHAR2 | (30) | ||
ADD_ALL_TO_CHANGE_FLAG | VARCHAR2 | (1) | ||
CHANGE_MGMT_TYPE_CODE | VARCHAR2 | (30) | ||
CHANGE_TYPE_ID | NUMBER | |||
CHANGE_NOTICE | VARCHAR2 | (10) | ||
CHANGE_NAME | VARCHAR2 | (240) | ||
CHANGE_DESCRIPTION | VARCHAR2 | (2000) | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
DEF_MATCH_RULE_CUST_APP_ID | NUMBER | |||
DEF_MATCH_RULE_CUST_CODE | VARCHAR2 | (30) | ||
DEF_MATCH_RULE_RN_APP_ID | NUMBER | |||
DEF_MATCH_RULE_RN_CODE | VARCHAR2 | (30) | ||
NIR_OPTION | VARCHAR2 | (1) | ||
ENABLED_FOR_DATA_POOL | VARCHAR2 | (1) | ||
CONFIRM_NO_MATCH | VARCHAR2 | (1) |
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#;
|
|
|