DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_TR_ALL_RESOURCES_V

Object Details
Object Name: JTF_TR_ALL_RESOURCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_TR_ALL_RESOURCES_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 resources


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER

Unqiue identifier of the resource
RESOURCE_NUMBER VARCHAR2 (30)
Unique Number of the resource
RESOURCE_TYPE VARCHAR2 (19)
Category of the resource
RESOURCE_NAME VARCHAR2 (360)
Name of the resource
EMAIL VARCHAR2 (2000)
Email address of the resource
START_DATE_ACTIVE DATE

Date from which the resource is active
END_DATE_ACTIVE DATE

Date from which the resource is inactive
PHONE VARCHAR2 (2000)
Phone of the resource
GROUP_ID NUMBER

Unique identifier of the group to which the resource belongs
GROUP_NAME VARCHAR2 (60)
Name of the group
ROLE VARCHAR2 (60)
Role that the resource plays in the group
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
,      GROUP_ID
,      GROUP_NAME
,      ROLE
FROM APPS.JTF_TR_ALL_RESOURCES_V;

Dependencies

[top of page]

APPS.JTF_TR_ALL_RESOURCES_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewJTF_RS_ALL_RESOURCES_VL
ViewJTF_RS_GROUPS_VL
ViewJTF_RS_GROUP_MEMBERS_VL
ViewJTF_RS_ROLE_RELATIONS_VL

APPS.JTF_TR_ALL_RESOURCES_V is not referenced by any database object