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

VIEW: APPS.EGO_RULE_SETS_VL

Object Details
Object Name: EGO_RULE_SETS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEGO.EGO_RULE_SETS_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
default rowid column
RULESET_ID NUMBER (15) Yes Uniquely identifies a Ruleset
RULESET_NAME VARCHAR2 (50) Yes Internal name of the Ruleset
RULESET_TYPE VARCHAR2 (50) Yes Ruleset Type
COMPOSITE VARCHAR2 (50) Yes checks if it is a composite ruleset
ITEM_CATALOG_CATEGORY NUMBER (15)
Reference to item catalog category to which the ruleset is associated
ATTR_GROUP_TYPE VARCHAR2 (60)
the attribute group type
ATTR_GROUP_NAME VARCHAR2 (50)
Attribute Group name
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
RULESET_DISPLAY_NAME VARCHAR2 (50)
Translated Ruleset display name
DESCRIPTION VARCHAR2 (256)
Translated Description of the Ruleset
Query Text

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


SELECT ROW_ID
,      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
,      RULESET_DISPLAY_NAME
,      DESCRIPTION
FROM APPS.EGO_RULE_SETS_VL;

Dependencies

[top of page]

APPS.EGO_RULE_SETS_VL references the following:

SchemaAPPS
SynonymEGO_RULE_SETS_B
SynonymEGO_RULE_SETS_TL

APPS.EGO_RULE_SETS_VL is not referenced by any database object