[Home] [Help]
[Dependency Information]
VIEW: APPS.ENG_SECURITY_PEOPLE_V
Object Details
Object Name: | ENG_SECURITY_PEOPLE_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ENG.ENG_SECURITY_PEOPLE_V
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A Web view designed to simplify access from Oracle Self-Service Web Applications.
ENG_SECURITY_PEOPLE_V stores information to display engineering people security information.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
PERSON_ID |
NUMBER |
(15) |
|
|
USER_ID |
NUMBER |
(15) |
|
|
USER_NAME |
VARCHAR2 |
(100) |
|
|
PERSON_TYPE |
VARCHAR2 |
(8) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, USER_ID
, USER_NAME
, PERSON_TYPE
FROM APPS.ENG_SECURITY_PEOPLE_V;
Dependencies
[top of page]
APPS.ENG_SECURITY_PEOPLE_V references the following:
-
APPS
-
FND_USER
-
HZ_CODE_ASSIGNMENTS
-
HZ_CUST_ACCOUNTS
-
PER_ALL_PEOPLE_F
APPS.ENG_SECURITY_PEOPLE_V is referenced by following:
-
APPS
-
EGO_REPORT_WF_UTIL
- show dependent code
-
ENG_WORKFLOW_UTIL
- show dependent code