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

VIEW: APPS.CS_JTF_RESOURCES_V

Object Details
Object Name: CS_JTF_RESOURCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_JTF_RESOURCES_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER

Resouce identifier
RESOURCE_NUMBER VARCHAR2 (30)
Resource number
RESOURCE_CATEGORY VARCHAR2 (30)
Resource category
RESOURCE_NAME VARCHAR2 (394)
Resource name
ADDRESS VARCHAR2 (1269)
Address of the resource
COUNTRY VARCHAR2 (60)
Country of resource
WORK_PHONE_NUMBER VARCHAR2 (4000)
Resource contact numbers.
CELL_PHONE_NUMBER VARCHAR2 (4000)
Resource contact numbers.
PAGER_PHONE_NUMBER VARCHAR2 (4000)
Resource contact numbers.
EMAIL_ADDRESS VARCHAR2 (4000)
Email address of the resource
FAX_NUMBER VARCHAR2 (4000)
Resource contact numbers.
HOME_PHONE_NUMBER VARCHAR2 (4000)
Resource contact numbers.
Query Text

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


SELECT RESOURCE_ID
,      RESOURCE_NUMBER
,      RESOURCE_CATEGORY
,      RESOURCE_NAME
,      ADDRESS
,      COUNTRY
,      WORK_PHONE_NUMBER
,      CELL_PHONE_NUMBER
,      PAGER_PHONE_NUMBER
,      EMAIL_ADDRESS
,      FAX_NUMBER
,      HOME_PHONE_NUMBER
FROM APPS.CS_JTF_RESOURCES_V;

Dependencies

[top of page]

APPS.CS_JTF_RESOURCES_V references the following:

SchemaAPPS
PL/SQL PackageCS_PARTIES_PKG - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymJTF_RS_RESOURCE_EXTNS
SynonymPER_ADDRESSES
ViewPER_PEOPLE_F
SynonymPER_PHONES

APPS.CS_JTF_RESOURCES_V is not referenced by any database object