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_TERR_QLFY_RSC_V

Object Details

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

View Type

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

This view stores all the informations about resources, groups and teams .

[View Source]

Columns

Name	Datatype	Length	Comments
RESOURCE_ID	NUMBER		Unique identifier of the resource or group or team
RESOURCE_NUMBER	VARCHAR2	(30)	Unique Number of the resource or group or team
RESOURCE_TYPE	VARCHAR2	(19)	Resource category in case of resource , RS_GROUP in case of group and RS_TEAM in case of team
RESOURCE_NAME	VARCHAR2	(786)	Name of the resource or group or team
EMAIL	VARCHAR2	(2000)	Email address of the resource or group or team
START_DATE_ACTIVE	DATE		The date when the resource or group or team became active
END_DATE_ACTIVE	DATE		The date when the resource or group or team became inactive
PHONE	VARCHAR2	(2000)	Phone number of the resource , not populated for group or team
CATEGORY	VARCHAR2	(30)	Category of the resource , not populated for group or team
JOB_ID	NUMBER		Unique identifier of the job of the resource , not populated for group or team
JOB_TITLE	VARCHAR2	(700)	Title of the job of the resource , not populated for group or team
POSITION_ID	NUMBER		Position of the resource , not populated for group or team
POSITION	VARCHAR2	(240)	Name of the position of the resource , not populated for group or team
LANGUAGE	VARCHAR2	(30)	Primary language of the resource , not populated for group or team
COMPETENCE_ID	NUMBER		Unqiue identifier of the competence of the resource , not populated for group or team
PROFICIENCY_LEVEL_ID	NUMBER		Proficiency level of the resource in the competence , not populated for group or team
CITY	VARCHAR2	(60)	City of the resource , not populated for group or team
POSTAL_CODE	VARCHAR2	(60)	Postal code of the resource , not populated for group or team

Query Text

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


SELECT RESOURCE_ID
,      RESOURCE_NUMBER
,      RESOURCE_TYPE
,      RESOURCE_NAME
,      EMAIL
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PHONE
,      CATEGORY
,      JOB_ID
,      JOB_TITLE
,      POSITION_ID
,      POSITION
,      LANGUAGE
,      COMPETENCE_ID
,      PROFICIENCY_LEVEL_ID
,      CITY
,      POSTAL_CODE
FROM APPS.JTF_TERR_QLFY_RSC_V;

Dependencies

[top of page]

APPS.JTF_TERR_QLFY_RSC_V references the following:

APPS: HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; JTF_RS_GROUPS_VL; JTF_RS_PARTY_CONTACTS_VL; JTF_RS_RESOURCE_EXTNS; JTF_RS_SALESREPS; JTF_RS_TEAMS_VL; ORG_ORGANIZATION_DEFINITIONS; PER_ALL_POSITIONS; PER_ASSIGNMENTS_F; PER_COMPETENCES; PER_COMPETENCE_ELEMENTS; PER_JOBS; PER_RATING_LEVELS

APPS.JTF_TERR_QLFY_RSC_V is not referenced by any database object