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_EMP_DTLS_VL

Object Details

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

View Type

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

This view has the details of all the resources whose category='EMPLOYEE'

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER		Yes	Unique Resource Indentifier.
RESOURCE_NUMBER	VARCHAR2	(30)	Yes	Another Unique identifier for resource , visible to user.
SOURCE_ID	NUMBER			Source identifier (foreign key to PER_ALL_PEOPLE_F)
ADDRESS_ID	NUMBER			Address identifier (foreign key to HZ_PARTY_SITES)
CONTACT_ID	NUMBER			Contact identifier (foreign key to HZ_ORG_CONTACTS)
START_DATE_ACTIVE	DATE		Yes	Date on which this resource become active.
END_DATE_ACTIVE	DATE			The date after which this resource will become inactive.
TIME_ZONE	NUMBER			Time Zone in which this Resource lives in,used by service
COST_PER_HR	NUMBER			Time Zone in which this Resource lives in,used by service
PRIMARY_LANGUAGE	VARCHAR2	(30)		Primary language , the resource speak.
SECONDARY_LANGUAGE	VARCHAR2	(30)		Secondary language of Resource
SUPPORT_SITE_ID	NUMBER			Support_site_id to which this resource_belongs to. Foreign Key to HZ_PARTY_SITES
IES_AGENT_LOGIN	VARCHAR2	(240)		Ies Agent login used by interaction center.
SERVER_GROUP_ID	NUMBER			Server Group Identifier to which this resource is attached. FK to IEO_SVR_GROUPS
ASSIGNED_TO_GROUP_ID	NUMBER			Assigned to User Identifier , Foreign Key to FND_USER.
COST_CENTER	VARCHAR2	(30)		Cost Center to which this resource is attached
CHARGE_TO_COST_CENTER	VARCHAR2	(30)		Cost center which will be charged to this resource
COMPENSATION_CURRENCY_CODE	VARCHAR2	(15)		The currency code in which ther resource will be compensated.
COMMISSIONABLE_FLAG	VARCHAR2	(1)		Flag which indicates whether the resource is commissionable or not.
HOLD_REASON_CODE	VARCHAR2	(30)		Reason Code for hold payment .
HOLD_PAYMENT	VARCHAR2	(1)		Flag indicating whther the payment for the resource is on hold or not.
COMP_SERVICE_TEAM_ID	NUMBER			Comp service team identifier FK to jtf_rs_teams_vl
TRANSACTION_NUMBER	NUMBER			Transaction Number. This will use at the time of import Resources.
FIRST_NAME	VARCHAR2	(360)		Resource (Employee) First Name
LAST_NAME	VARCHAR2	(360)		last name of the Resource (Employee)
MIDDLE_NAME	VARCHAR2	(360)		Middle Name of Resource ( Employee)
FULL_NAME	VARCHAR2	(360)		Full Name of Resource (Employee)
EMPLOYEE_NUMBER	VARCHAR2	(30)		Resource's Employee Number
PHONE	VARCHAR2	(2000)		Phone of Resource (Employee)
EMAIL	VARCHAR2	(2000)		Phone number of Resource (Employee)
JOB_TITLE	VARCHAR2	(240)		Job Title of Resource (Employee)
MANAGER_PERSON_ID	NUMBER			Person id of manager of Resource (employee)
MANAGER_NAME	VARCHAR2	(360)		Resource ( Employee ) Manager's Name
EFFECTIVE_START_DATE	DATE		Yes	Date on which This person ( Resource ) becomes active in HR
EFFECTIVE_END_DATE	DATE			Date after which This person (Employee ) becomes inactive in HR
EMP_CATEGORY	VARCHAR2	(360)		Employement Category of Resource ( Temporary,full time, part time etc)
EMP_STATUS	VARCHAR2	(360)		Employment status of Resource like active, transferred,retired
ORG_ID	NUMBER			Organization identifier
ORG_NAME	VARCHAR2	(360)		Resource's (Employee) Organization Name
USER_ID	NUMBER			User Id attached to this resource ( Employee), FK to FND_USER
RESOURCE_NAME	VARCHAR2	(360)		Resource Name.
JOB_ID	NUMBER			Job Id
PERSON_PARTY_ID	NUMBER			Party Id

Query Text

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


SELECT RESOURCE_ID
,      RESOURCE_NUMBER
,      SOURCE_ID
,      ADDRESS_ID
,      CONTACT_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      TIME_ZONE
,      COST_PER_HR
,      PRIMARY_LANGUAGE
,      SECONDARY_LANGUAGE
,      SUPPORT_SITE_ID
,      IES_AGENT_LOGIN
,      SERVER_GROUP_ID
,      ASSIGNED_TO_GROUP_ID
,      COST_CENTER
,      CHARGE_TO_COST_CENTER
,      COMPENSATION_CURRENCY_CODE
,      COMMISSIONABLE_FLAG
,      HOLD_REASON_CODE
,      HOLD_PAYMENT
,      COMP_SERVICE_TEAM_ID
,      TRANSACTION_NUMBER
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAME
,      FULL_NAME
,      EMPLOYEE_NUMBER
,      PHONE
,      EMAIL
,      JOB_TITLE
,      MANAGER_PERSON_ID
,      MANAGER_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EMP_CATEGORY
,      EMP_STATUS
,      ORG_ID
,      ORG_NAME
,      USER_ID
,      RESOURCE_NAME
,      JOB_ID
,      PERSON_PARTY_ID
FROM APPS.JTF_RS_EMP_DTLS_VL;

Dependencies

[top of page]

APPS.JTF_RS_EMP_DTLS_VL references the following:

APPS: JTF_RS_RESOURCE_EXTNS_VL

APPS.JTF_RS_EMP_DTLS_VL is referenced by following:

APPS: ASG_CREATE_NEW_USERS_VL; AST_RS_CAMPAIGNS_V; AST_RS_CAMPAIGN_SCHEDS_V; AS_LEAD_ABANDON_WF - show dependent code; CSC_TASK_OWNERS_V; CS_SR_OWNERS_V; JTF_EC_PUB - show dependent code; JTF_EC_WORKFLOW_PKG - show dependent code; JTF_ESCWFACTIVITY_PVT - show dependent code