DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.POS_PO_USER_DETAILS_V

Object Details
Object Name: POS_PO_USER_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_PO_USER_DETAILS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This View Displays the User Information from FND_USER


[View Source]

Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Yes User Identifier
USER_NAME VARCHAR2 (100) Yes User Name
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER (15) Yes Last Updated By
CREATION_DATE DATE
Yes Creation Date
CREATED_BY NUMBER (15) Yes Created By
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login
ENCRYPTED_FOUNDATION_PASSWORD VARCHAR2 (100) Yes Encrypted Foundation Password
ENCRYPTED_USER_PASSWORD VARCHAR2 (100) Yes Encrypted User Password
SESSION_NUMBER NUMBER
Yes Session Number
START_DATE DATE
Yes Start Date
END_DATE DATE

End Date
DESCRIPTION VARCHAR2 (240)
Description
LAST_LOGON_DATE DATE

Last Logon Date
PASSWORD_DATE DATE

Password Date
PASSWORD_ACCESSES_LEFT NUMBER (15)
Password Accesses Left
PASSWORD_LIFESPAN_ACCESSES NUMBER (15)
Password Lifespan Accesses
PASSWORD_LIFESPAN_DAYS NUMBER (15)
Password Lifespan Days
EMPLOYEE_ID NUMBER (15)
Employee Identifier
EMAIL_ADDRESS VARCHAR2 (240)
E-mail Address
FAX VARCHAR2 (80)
Fax
USER_PASSWORD VARCHAR2 (240)
User Password
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
,      USER_PASSWORD
FROM APPS.POS_PO_USER_DETAILS_V;

Dependencies

[top of page]

APPS.POS_PO_USER_DETAILS_V references the following:

SchemaAPPS
SynonymFND_USER

APPS.POS_PO_USER_DETAILS_V is not referenced by any database object