[Home] [Help] [Dependency Information]
Object Name: | PER_SECURITY_USERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.PER_SECURITY_USERS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SECURITY_USER_ID | NUMBER | (15) | Yes | SECURITY_USER_ID From PER_SECURITY_USERS |
SECURITY_PROFILE_ID | NUMBER | (15) | Yes | SECURITY_PROFILE_ID from PER_SECURITY_USERS |
USER_ID | NUMBER | (15) | Yes | USER_ID from PER_SECURITY_USERS |
USER_NAME | VARCHAR2 | (100) | Yes | USER_NAME from FND_USER |
PERSON_ID | NUMBER | (15) | EMPLOYEE_ID from FND_USER | |
FULL_NAME | VARCHAR2 | (240) | FULL_NAME from PER_ALL_PEOPLE_F | |
PROCESS_IN_NEXT_RUN_FLAG | VARCHAR2 | (30) | PROCESS_IN_NEXT_RUN_FLAG from PER_SECURITY_USERS | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | OBJECT_VERSION_NUMBER from PER_SECURITY_USERS |
CREATED_BY | NUMBER | (15) | Standard Who column. From PER_SECURITY_USERS. | |
CREATION_DATE | DATE | Standard Who column. From PER_SECURITY_USERS. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column. From PER_SECURITY_USERS. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standrad Who column. From PER_SECURITY_USERS. | |
LAST_UPDATE_DATE | DATE | Standard Who column. From PER_SECURITY_USERS. |
Cut, paste (and edit) the following text to query this object:
SELECT SECURITY_USER_ID
, SECURITY_PROFILE_ID
, USER_ID
, USER_NAME
, PERSON_ID
, FULL_NAME
, PROCESS_IN_NEXT_RUN_FLAG
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
FROM APPS.PER_SECURITY_USERS_V;
|
|
|