[Home] [Help] [Dependency Information]
Object Name: | AME_CONFIG_VARS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.AME_CONFIG_VARS_VL is not referenced by any database object
|
|
|