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


VIEW: APPS.OKS_HELP_DESK_V

Object Details
Object Name: OKS_HELP_DESK_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID


View is used for Global Default help desk.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row id of fnd_user
USER_ID NUMBER (15) Yes user id from fnd_user.
USER_NAME VARCHAR2 (100) Yes User name from fnd_user.
HELP_DESK_NAME VARCHAR2 (240)
EMAIL_ADDRESS VARCHAR2 (240)
RESOURCE_ID NUMBER
Yes
Query Text

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


SELECT ROW_ID
,      USER_ID
,      USER_NAME
,      HELP_DESK_NAME
,      EMAIL_ADDRESS
,      RESOURCE_ID
FROM APPS.OKS_HELP_DESK_V;

Dependencies

[top of page]

APPS.OKS_HELP_DESK_V references the following:

SchemaAPPS
SynonymFND_USER
SynonymJTF_RS_RESOURCE_EXTNS
ViewOKX_PER_ALL_PEOPLE_V

APPS.OKS_HELP_DESK_V is not referenced by any database object