[Home] [Help] [Dependency Information]
Object Name: | JTM_FND_USER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_ID | NUMBER | Yes | ||
USER_ID | NUMBER | (15) | Yes | Application user identifier |
USER_NAME | VARCHAR2 | (100) | Yes | Application username (what a user types in at the Oracle Applications sign-on screen) |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ENCRYPTED_FOUNDATION_PASSWORD | VARCHAR2 | (100) | Yes | The Oracle Application Object Library encrypted password used to connect to database |
ENCRYPTED_USER_PASSWORD | VARCHAR2 | (100) | Yes | The encrypted password for the application user to sign on to Oracle Applications |
SESSION_NUMBER | NUMBER | Yes | The session number of the application user's last sign-on session | |
START_DATE | DATE | Yes | The date the password becomes active | |
END_DATE | DATE | The date the password expires | ||
DESCRIPTION | VARCHAR2 | (240) | Description | |
LAST_LOGON_DATE | DATE | The date the application user last signed on | ||
PASSWORD_DATE | DATE | The date the current password was set | ||
PASSWORD_ACCESSES_LEFT | NUMBER | (15) | The number of accesses left for the password | |
PASSWORD_LIFESPAN_ACCESSES | NUMBER | (15) | The number of accesses allowed for the password | |
PASSWORD_LIFESPAN_DAYS | NUMBER | (15) | Lifespan of the password | |
EMPLOYEE_ID | NUMBER | (15) | Identifier of employee to whom the application username is assigned | |
EMAIL_ADDRESS | VARCHAR2 | (240) | The Electronic mail address for the user | |
FAX | VARCHAR2 | (80) | The fax number for the user | |
CUSTOMER_ID | NUMBER | (15) | Customer contact identifier. If the AOL user is a customer contact, this value is a foreign key to the corresponding customer contact. | |
SUPPLIER_ID | NUMBER | (15) | Supplier contact identifier. If the AOL user is a supplier contact, this value is a foreign key to the corresponding supplier contact. | |
WEB_PASSWORD | VARCHAR2 | (240) | Unused |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_ID
, USER_ID
, USER_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ENCRYPTED_FOUNDATION_PASSWORD
, ENCRYPTED_USER_PASSWORD
, SESSION_NUMBER
, START_DATE
, END_DATE
, DESCRIPTION
, LAST_LOGON_DATE
, PASSWORD_DATE
, PASSWORD_ACCESSES_LEFT
, PASSWORD_LIFESPAN_ACCESSES
, PASSWORD_LIFESPAN_DAYS
, EMPLOYEE_ID
, EMAIL_ADDRESS
, FAX
, CUSTOMER_ID
, SUPPLIER_ID
, WEB_PASSWORD
FROM APPS.JTM_FND_USER_V;
APPS.JTM_FND_USER_V is not referenced by any database object
|
|
|