[Home] [Help] [Dependency Information]
Object Name: | JTF_UM_USERTYPES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_UM_USERTYPES_VL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
MultiLingual view (a language resolved view of the data.)
MLS view for JTF_UM_USERTYPES_B and JTF_UM_USERTYPES_TL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
USERTYPE_ID | NUMBER | (15) | Yes | |
APPROVAL_ID | NUMBER | (15) | ||
ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
USERTYPE_KEY | VARCHAR2 | (30) | Yes | |
IS_SELF_SERVICE_FLAG | VARCHAR2 | (1) | Yes | |
EMAIL_NOTIFICATION_FLAG | VARCHAR2 | (1) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
SECURITY_GROUP_ID | NUMBER | (15) | ||
APPLICATION_ID | NUMBER | (15) | Yes | |
EFFECTIVE_START_DATE | DATE | Yes | ||
EFFECTIVE_END_DATE | DATE | |||
USERTYPE_NAME | VARCHAR2 | (1000) | Yes | |
USERTYPE_SHORTNAME | VARCHAR2 | (230) | Yes | Used in the Registration Confirmation page and in Workflow Notifications |
DESCRIPTION | VARCHAR2 | (2000) | Yes | |
DISPLAY_ORDER | NUMBER | (15) | Display Order |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, USERTYPE_ID
, APPROVAL_ID
, ENABLED_FLAG
, USERTYPE_KEY
, IS_SELF_SERVICE_FLAG
, EMAIL_NOTIFICATION_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, APPLICATION_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, USERTYPE_NAME
, USERTYPE_SHORTNAME
, DESCRIPTION
, DISPLAY_ORDER
FROM APPS.JTF_UM_USERTYPES_VL;
|
|
|