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

VIEW: APPS.AME_RULES_VL

Object Details
Object Name: AME_RULES_VL
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This view provides the details of rules with translated details in the current session language. This view is join between ame_rules and ame_rules_tl based on current session language.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes Rule identifier
RULE_TYPE NUMBER
Yes Rule type
ACTION_ID NUMBER

Not used
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
START_DATE DATE
Yes Date on which row is activated
END_DATE DATE

Date on which row is inactivated
DESCRIPTION VARCHAR2 (300) Yes Rule description
SECURITY_GROUP_ID NUMBER (15)
Not used
RULE_KEY VARCHAR2 (100) Yes Rule key
ITEM_CLASS_ID NUMBER (15)
Item class for which rule belongs
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update
Query Text

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


SELECT RULE_ID
,      RULE_TYPE
,      ACTION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      START_DATE
,      END_DATE
,      DESCRIPTION
,      SECURITY_GROUP_ID
,      RULE_KEY
,      ITEM_CLASS_ID
,      OBJECT_VERSION_NUMBER
FROM APPS.AME_RULES_VL;

Dependencies

[top of page]

APPS.AME_RULES_VL references the following:

SchemaAPPS
SynonymAME_RULES
SynonymAME_RULES_TL
APPS.AME_RULES_VL is referenced by following:

SchemaAPPS
ViewAME_RULES_V
Package BodyAME_TEST_UTILITY_PKG - show dependent code
Package BodyEDR_RULE_TEMP - show dependent code