[Home] [Help] [Dependency Information]
Object Name: | AME_APPROVAL_GROUPS_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 approver groups with translated details in the current session language. This view is join between ame_approval_groups and ame_approval_groups_tl based on current session language.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPROVAL_GROUP_ID | NUMBER | Yes | Approver group identifier | |
NAME | VARCHAR2 | (50) | Yes | Approver group name |
USER_APPROVAL_GROUP_NAME | VARCHAR2 | (150) | Approver group display name | |
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) | Description | |
QUERY_STRING | VARCHAR2 | (4000) | Sql statement to fetch the members of a dynamic approver group | |
IS_STATIC | VARCHAR2 | (1) | Indicates whether approver group is static or not | |
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 APPROVAL_GROUP_ID
, NAME
, USER_APPROVAL_GROUP_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, START_DATE
, END_DATE
, DESCRIPTION
, QUERY_STRING
, IS_STATIC
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM APPS.AME_APPROVAL_GROUPS_VL;
|
|
|