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

VIEW: APPS.AME_CONFIG_VARS_VL

Object Details
Object Name: AME_CONFIG_VARS_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 configuration variable with translated details in the current session language. This view is join between ame_config_vars and ame_config_vars_tl based on current session language.


[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER

AME internal application identifier which identifies a transaction type
VARIABLE_NAME VARCHAR2 (50) Yes Configuration variable name
VARIABLE_VALUE VARCHAR2 (200) Yes Configuration variable value
USER_CONFIG_VAR_NAME VARCHAR2 (150)
Configuration variable name
DESCRIPTION VARCHAR2 (300) Yes Configuration variable description
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
SECURITY_GROUP_ID NUMBER (15)
Not used
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 APPLICATION_ID
,      VARIABLE_NAME
,      VARIABLE_VALUE
,      USER_CONFIG_VAR_NAME
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      START_DATE
,      END_DATE
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM APPS.AME_CONFIG_VARS_VL;

Dependencies

[top of page]

APPS.AME_CONFIG_VARS_VL references the following:

SchemaAPPS
SynonymAME_CONFIG_VARS
SynonymAME_CONFIG_VARS_TL

APPS.AME_CONFIG_VARS_VL is not referenced by any database object