[Home] [Help] [Dependency Information]
Object Name: | EGO_RULE_SETS_B |
---|---|
Object Type: | TABLE |
Owner: | EGO |
FND Design Data: | EGO.EGO_RULE_SETS_B |
Subobject Name: | |
Status: | VALID |
This table is used to store the Ruleset metadata.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EGO_RULE_SETS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RULESET_ID
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULESET_ID | NUMBER | (15) | Yes | Rule set Identifier, Uniquely identifies the Ruleset |
RULESET_NAME | VARCHAR2 | (50) | Yes | Ruleset Internal Name |
RULESET_TYPE | VARCHAR2 | (50) | Yes | Identifies the type of the Ruleset. One of Validations or Assignment |
COMPOSITE | VARCHAR2 | (50) | Yes | checks if the ruleset is a composite Ruleset |
ITEM_CATALOG_CATEGORY | NUMBER | (15) | Item Catalog Category Id to which the Ruleset is associated to | |
ATTR_GROUP_TYPE | VARCHAR2 | (60) | The attribute group type of the attribute group to which the Ruleset is associated | |
ATTR_GROUP_NAME | VARCHAR2 | (50) | The Attribute Group name to which the Ruleset is associated | |
LAST_UPDATE_DATE | DATE | Yes | One of the five standard "WHO" columns | |
LAST_UPDATED_BY | NUMBER | Yes | One of the five standard "WHO" columns | |
CREATION_DATE | DATE | Yes | One of the five standard "WHO" columns | |
CREATED_BY | NUMBER | Yes | One of the five standard "WHO" columns | |
LAST_UPDATE_LOGIN | NUMBER | One of the five standard "WHO" columns | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT RULESET_ID
, RULESET_NAME
, RULESET_TYPE
, COMPOSITE
, ITEM_CATALOG_CATEGORY
, ATTR_GROUP_TYPE
, ATTR_GROUP_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM EGO.EGO_RULE_SETS_B;
EGO.EGO_RULE_SETS_B does not reference any database object
EGO.EGO_RULE_SETS_B is referenced by following:
|
|
|