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_OTHER_DTLS_VL

Object Details

Object Name:	JTF_RS_OTHER_DTLS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_RS_OTHER_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='OTHER'

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER		Yes	Resource Identifier
RESOURCE_NUMBER	VARCHAR2	(30)	Yes	Resource Number. This is a Unique number.
SOURCE_ID	NUMBER			Source identifier (null in this case)
ADDRESS_ID	NUMBER			Address identifier (null in this case)
CONTACT_ID	NUMBER			Contact dentifier (null in this case)
START_DATE_ACTIVE	DATE		Yes	Date this Resource becomes active
END_DATE_ACTIVE	DATE			Date this Resource becomes inactive, if limited
TIME_ZONE	NUMBER			This field is used by Service for time zone information (foreign key to HZ_TIMEZONES)
COST_PER_HR	NUMBER			This field is used by Service for cost per hour information
PRIMARY_LANGUAGE	VARCHAR2	(30)		This field is used by Service for the primary language of the resource
SECONDARY_LANGUAGE	VARCHAR2	(30)		This field is used by Service for the secondary language of the resource
SUPPORT_SITE_ID	NUMBER			Support Site from Service
IES_AGENT_LOGIN	VARCHAR2	(240)		Email Center Agent Login
SERVER_GROUP_ID	NUMBER			Server Group Identifier
ASSIGNED_TO_GROUP_ID	NUMBER			Assigned To Group Id
COST_CENTER	VARCHAR2	(30)		Cost Center
CHARGE_TO_COST_CENTER	VARCHAR2	(30)		Charge to Cost Center
COMPENSATION_CURRENCY_CODE	VARCHAR2	(15)		Compensation currency Code
COMMISSIONABLE_FLAG	VARCHAR2	(1)		Commissionable Flag
HOLD_REASON_CODE	VARCHAR2	(30)		Hold Resaon code
HOLD_PAYMENT	VARCHAR2	(1)		Hold Payment
COMP_SERVICE_TEAM_ID	NUMBER			Comp Serveice team identifier
TRANSACTION_NUMBER	NUMBER			Transaction Number. This will use at the time of import Resources.
RESOURCE_NAME	VARCHAR2	(360)		The resource name
ORG_ID	NUMBER			Organization identifier
ORG_NAME	VARCHAR2	(240)		Organization name
PHONE	VARCHAR2	(0)		The phone no of the resource
EMAIL	VARCHAR2	(240)		Email
USER_ID	NUMBER			The user id for the resource
CATEGORY	VARCHAR2	(30)	Yes	Resource Category.

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
,      RESOURCE_NAME
,      ORG_ID
,      ORG_NAME
,      PHONE
,      EMAIL
,      USER_ID
,      CATEGORY
FROM APPS.JTF_RS_OTHER_DTLS_VL;

Dependencies

[top of page]

APPS.JTF_RS_OTHER_DTLS_VL references the following:

APPS: HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; JTF_RS_RESOURCE_EXTNS_VL; JTF_RS_SALESREPS; ORG_ORGANIZATION_DEFINITIONS

APPS.JTF_RS_OTHER_DTLS_VL is not referenced by any database object