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

VIEW: APPS.ENG_CHANGE_RULE_ATTRIBUTES_VL

Object Details
Object Name: ENG_CHANGE_RULE_ATTRIBUTES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.ENG_CHANGE_RULE_ATTRIBUTES_VL
Subobject Name:
Status: VALID

View Type

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE_OBJECT_NAME VARCHAR2 (30) Yes Object internal name
ATTRIBUTE_CODE VARCHAR2 (30) Yes Attribute code
ATTRIBUTE_COLUMN_TYPE VARCHAR2 (10)
Datatype of the attribute code column
LOV_SQL VARCHAR2 (2000)
SQL to retrieve the LOV
ATTRIBUTE_NAME VARCHAR2 (80)
Display name of the attribute
DISPLAY_COLUMN1_NAME VARCHAR2 (80)
Display column name1
DISPLAY_COLUMN2_NAME VARCHAR2 (80)
Display column name2
LANGUAGE VARCHAR2 (4) Yes Language
CREATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
ATTRIBUTE_CLASS_CODE VARCHAR2 (1)
Attribute classification code
Query Text

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


SELECT ATTRIBUTE_OBJECT_NAME
,      ATTRIBUTE_CODE
,      ATTRIBUTE_COLUMN_TYPE
,      LOV_SQL
,      ATTRIBUTE_NAME
,      DISPLAY_COLUMN1_NAME
,      DISPLAY_COLUMN2_NAME
,      LANGUAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      ATTRIBUTE_CLASS_CODE
FROM APPS.ENG_CHANGE_RULE_ATTRIBUTES_VL;

Dependencies

[top of page]

APPS.ENG_CHANGE_RULE_ATTRIBUTES_VL references the following:

SchemaAPPS
SynonymENG_CHANGE_RULE_ATTRIBUTES_B
SynonymENG_CHANGE_RULE_ATTRIBUTES_TL
APPS.ENG_CHANGE_RULE_ATTRIBUTES_VL is referenced by following:

SchemaAPPS
Package BodyENGPKIMP - show dependent code
Package BodyENG_CHANGE_POLICY_PKG - show dependent code
Package BodyENG_DOM_UTIL_PUB - show dependent code