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

TABLE: EGO.EGO_ONDEMAND_RULES_ATTRS_B

Object Details
Object Name: EGO_ONDEMAND_RULES_ATTRS_B
Object Type: TABLE
Owner: EGO
FND Design Data: TableEGO.EGO_ONDEMAND_RULES_ATTRS_B
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EGO_ONDEMAND_RULES_ATTRS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnATTR_LEVEL_ID
Columns
Name Datatype Length Mandatory Comments
ATTR_LEVEL_ID NUMBER (15) Yes
ITEM_LEVEL_ID NUMBER (15) Yes
ATTR_INT_NAME VARCHAR2 (30)
RULESET_ID NUMBER (15) Yes
USER_RULE_ID NUMBER (15) Yes
VALIDATION_SEVERITY VARCHAR2 (30)
VALIDATION_RESULT VARCHAR2 (30)
BEFORE_VALUE_N NUMBER (15)
AFTER_VALUE_N NUMBER (15)
BEFORE_VALUE_C VARCHAR2 (300)
AFTER_VALUE_C VARCHAR2 (300)
BEFORE_VALUE_D DATE

AFTER_VALUE_D DATE

RESULT_MESSAGE VARCHAR2 (1024)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
ATTR_GROUP_NAME VARCHAR2 (30)
ATTR_GROUP_TYPE VARCHAR2 (40)
ATTR_GROUP_ID NUMBER (22)
Query Text

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


SELECT ATTR_LEVEL_ID
,      ITEM_LEVEL_ID
,      ATTR_INT_NAME
,      RULESET_ID
,      USER_RULE_ID
,      VALIDATION_SEVERITY
,      VALIDATION_RESULT
,      BEFORE_VALUE_N
,      AFTER_VALUE_N
,      BEFORE_VALUE_C
,      AFTER_VALUE_C
,      BEFORE_VALUE_D
,      AFTER_VALUE_D
,      RESULT_MESSAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTR_GROUP_NAME
,      ATTR_GROUP_TYPE
,      ATTR_GROUP_ID
FROM EGO.EGO_ONDEMAND_RULES_ATTRS_B;

Dependencies

[top of page]

EGO.EGO_ONDEMAND_RULES_ATTRS_B does not reference any database object

EGO.EGO_ONDEMAND_RULES_ATTRS_B is referenced by following:

SchemaEGO
ViewEGO_ONDEMAND_RULES_ATTRS_B#