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

VIEW: APPS.JTF_RS_RESOURCES_VL

Object Details
Object Name: JTF_RS_RESOURCES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_RS_RESOURCES_VL
Subobject Name:
Status: VALID

View Type

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


This view shows all resource including team,groups and individual resource.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER

Resource Identifier.
RESOURCE_NUMBER VARCHAR2 (30)
Resource Number.
RESOURCE_TYPE VARCHAR2 (19)
Resource type.
RESOURCE_NAME VARCHAR2 (360)
Resource Name.
EMAIL VARCHAR2 (2000)
Email associated with the resource.
START_DATE_ACTIVE DATE

Effective start date of the resource.
END_DATE_ACTIVE DATE

Effective end date of this resource.
PHONE VARCHAR2 (2000)
Resource phone number.
PERSON_PARTY_ID NUMBER

Party Id
ORG_ID NUMBER

Operating Unit Identifier
ORG_NAME VARCHAR2 (360)
Operating Unit Name
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
,      PERSON_PARTY_ID
,      ORG_ID
,      ORG_NAME
FROM APPS.JTF_RS_RESOURCES_VL;

Dependencies

[top of page]

APPS.JTF_RS_RESOURCES_VL references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewJTF_RS_GROUPS_VL
ViewJTF_RS_RESOURCE_DTLS_VL
ViewJTF_RS_TEAMS_VL
APPS.JTF_RS_RESOURCES_VL is referenced by following:

SchemaAPPS
Package BodyJTF_TERRITORY_RESOURCE_PVT - show dependent code
Package BodyJTY_WEBADI_OTH_TERR_DWNL_PKG - show dependent code