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

VIEW: APPS.JTF_RS_RESOURCE_DTLS_VL

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

View Type

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


This view is for the details (eg name , phone, email) for the resources


[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER

Resource identifier
CATEGORY VARCHAR2 (30)
Resoiurce Category
RESOURCE_NUMBER VARCHAR2 (30)
Resource Number
RESOURCE_NAME VARCHAR2 (360)
Resource name
SOURCE_ID NUMBER

Source Identifier
ADDRESS_ID NUMBER

Address Identifier
CONTACT_ID NUMBER

Contact Identifier
MANAGING_EMPLOYEE_ID NUMBER

The employee id of the supervisor
SUPPORT_SITE_ID NUMBER

Support site identifier
ORG_ID NUMBER

Organization identifier
ORG_NAME VARCHAR2 (360)
Organization name
EMAIL VARCHAR2 (2000)
Email address
START_DATE_ACTIVE DATE

Date this resource becomes active
END_DATE_ACTIVE DATE

Date this resource becomes inactive, if limited
PHONE VARCHAR2 (2000)
Phone number
USER_ID NUMBER

User id
PERSON_PARTY_ID NUMBER

Party Id
Query Text

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


SELECT RESOURCE_ID
,      CATEGORY
,      RESOURCE_NUMBER
,      RESOURCE_NAME
,      SOURCE_ID
,      ADDRESS_ID
,      CONTACT_ID
,      MANAGING_EMPLOYEE_ID
,      SUPPORT_SITE_ID
,      ORG_ID
,      ORG_NAME
,      EMAIL
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      PHONE
,      USER_ID
,      PERSON_PARTY_ID
FROM APPS.JTF_RS_RESOURCE_DTLS_VL;

Dependencies

[top of page]

APPS.JTF_RS_RESOURCE_DTLS_VL references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
ViewJTF_RS_RESOURCE_EXTNS_VL
SynonymJTF_RS_SALESREPS_MO_V
APPS.JTF_RS_RESOURCE_DTLS_VL is referenced by following:

SchemaAPPS
ViewJTF_RS_ALL_RESOURCES_VL
ViewJTF_RS_RESOURCES_VL