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_DST_V

Object Details

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

View Type

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

This views stores all the active resources , groups and teams.

[View Source]

Columns

Name	Datatype	Length	Comments
RESOURCE_ID	NUMBER		Unique identifier of the resource or group or team
RESOURCE_TYPE	VARCHAR2	(19)	'RS_GROUP' in case of group , 'RS_TEAM' in case of team and resource category in case of resource
RESOURCE_TYPE_NAME	VARCHAR2	(17)	Description of resource type
RESOURCE_NAME	VARCHAR2	(360)	Resource name in case of resource , group name in case of group and team name in case of team
EMAIL	VARCHAR2	(0)	Not Used
START_DATE_ACTIVE	VARCHAR2	(0)	Not Used
END_DATE_ACTIVE	VARCHAR2	(0)	Not Used
PHONE	VARCHAR2	(0)	Not Used

Query Text

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


SELECT RESOURCE_ID
,      RESOURCE_TYPE
,      RESOURCE_TYPE_NAME
,      RESOURCE_NAME
,      EMAIL
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PHONE
FROM APPS.JTF_TERR_QLFY_RSC_DST_V;

Dependencies

[top of page]

APPS.JTF_TERR_QLFY_RSC_DST_V references the following:

APPS: JTF_RS_GROUPS_VL; JTF_RS_RESOURCE_EXTNS_VL; JTF_RS_TEAMS_VL

APPS.JTF_TERR_QLFY_RSC_DST_V is not referenced by any database object