eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	PO.POS_PO_USER_DETAILS_V POS.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:

APPS: FND_USER

APPS.POS_PO_USER_DETAILS_V is not referenced by any database object