[Home] [Help] [Dependency Information]
Object Name: | AME_ACTION_TYPES_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 action types with translated details in the current session language. This view is join between ame_action_types and ame_action_types_tl based on current session language.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_TYPE_ID | NUMBER | Yes | Action type identifier | |
USER_ACTION_TYPE_NAME | VARCHAR2 | (150) | Action type display name | |
NAME | VARCHAR2 | (50) | Yes | Action type name |
PROCEDURE_NAME | VARCHAR2 | (50) | Yes | PL/SQL package name that implements the action type handler |
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 | Action type description |
SECURITY_GROUP_ID | NUMBER | (15) | Not used | |
DYNAMIC_DESCRIPTION | VARCHAR2 | (1) | Indicates whether action type has dynamic description or not | |
DESCRIPTION_QUERY | VARCHAR2 | (4000) | Sql statement to fetch the dynamic description, if dynamic discription is enabled | |
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 ACTION_TYPE_ID
, USER_ACTION_TYPE_NAME
, NAME
, PROCEDURE_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, START_DATE
, END_DATE
, DESCRIPTION
, SECURITY_GROUP_ID
, DYNAMIC_DESCRIPTION
, DESCRIPTION_QUERY
, OBJECT_VERSION_NUMBER
FROM APPS.AME_ACTION_TYPES_VL;
|
|
|