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.JTF_RS_RES_EMP_VL

Object Details

Object Name:	JTF_RS_RES_EMP_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_RS_RES_EMP_VL
Subobject Name:
Status:	VALID

View Type

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

This view shows a few attributes of a Resource of type Employee

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER		Yes	Resource Identifier
USER_ID	NUMBER			User Id this resource is mapped to FND_USER
EMPLOYEE_ID	NUMBER	(10)	Yes	Employee Identifier
FIRST_NAME	VARCHAR2	(150)		First Name of the resource
LAST_NAME	VARCHAR2	(150)	Yes	Last Name of the employee
MIDDLE_NAME	VARCHAR2	(60)		Middle Name of the employee
FULL_NAME	VARCHAR2	(240)		Full Name of the employee
EMPLOYEE_NUMBER	VARCHAR2	(30)		The employee number of the employee
PHONE	VARCHAR2	(4000)		The phone number of the employee
EMAIL	VARCHAR2	(240)		The email of the employee

Query Text

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


SELECT RESOURCE_ID
,      USER_ID
,      EMPLOYEE_ID
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      FULL_NAME
,      EMPLOYEE_NUMBER
,      PHONE
,      EMAIL
FROM APPS.JTF_RS_RES_EMP_VL;

Dependencies

[top of page]

APPS.JTF_RS_RES_EMP_VL references the following:

APPS: HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; JTF_RS_RESOURCE_EXTNS; PER_ASSIGNMENTS_F; PER_PEOPLE_F; PER_PERIODS_OF_SERVICE

APPS.JTF_RS_RES_EMP_VL is referenced by following:

APPS: AMS_P_LIST_HEADERS_V; AST_LM_EVENTS_SRC_V; AST_LM_EVENTS_V