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


VIEW: APPS.PA_RESOURCE_AVAIL_STAFF_V

Object Details
Object Name: PA_RESOURCE_AVAIL_STAFF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_RESOURCE_AVAIL_STAFF_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RESOURCE_ANALYST_ID NUMBER (10) Yes
RESOURCE_ID NUMBER
Yes Internal identifier for the resource
RESOURCE_SOURCE_ID NUMBER
Yes
RESOURCE_NAME VARCHAR2 (240) Yes Full name of the resource
ORGANIZATION_ID NUMBER
Yes Internal identifier of the organization of a primary assignment for the resource
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization name of a primary assignment for the resource
MANAGER_ID NUMBER (15)
Internal identifier of the person to whom the resource directly reports
MANAGER_NAME VARCHAR2 (240)
Full name of the person to whom the resource directly reports
JOB_LEVEL NUMBER

Job level of the resource
RESOURCE_EFFECTIVE_START_DATE DATE
Yes Effective Start Date of the resource
RESOURCE_EFFECTIVE_END_DATE DATE

Effective End Date of the resource
RESOURCE_CITY VARCHAR2 (30)
Home city of the resource
RESOURCE_REGION VARCHAR2 (120)
Home region of the resource
RESOURCE_COUNTRY_CODE VARCHAR2 (2)
Home country code of the resource
RESOURCE_COUNTRY VARCHAR2 (60)
Home country of the resource
CURRENT_PROJECT_NAME_NUMBER VARCHAR2 (4000)
Project Name(Project Number) of the project that the resource is currently working on
CURRENT_PROJECT_ID NUMBER

RESOURCE_PERSON_TYPE VARCHAR2 (30)
Indicates whether the resource is a contingent worker or employee
RESOURCE_EMAIL_ADDRESS VARCHAR2 (240)
Email Address of the resource
Query Text

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


SELECT ROW_ID
,      RESOURCE_ANALYST_ID
,      RESOURCE_ID
,      RESOURCE_SOURCE_ID
,      RESOURCE_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      MANAGER_ID
,      MANAGER_NAME
,      JOB_LEVEL
,      RESOURCE_EFFECTIVE_START_DATE
,      RESOURCE_EFFECTIVE_END_DATE
,      RESOURCE_CITY
,      RESOURCE_REGION
,      RESOURCE_COUNTRY_CODE
,      RESOURCE_COUNTRY
,      CURRENT_PROJECT_NAME_NUMBER
,      CURRENT_PROJECT_ID
,      RESOURCE_PERSON_TYPE
,      RESOURCE_EMAIL_ADDRESS
FROM APPS.PA_RESOURCE_AVAIL_STAFF_V;

Dependencies

[top of page]

APPS.PA_RESOURCE_AVAIL_STAFF_V references the following:

SchemaAPPS
SynonymFND_GRANTS
SynonymFND_MENUS
SynonymFND_OBJECTS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymPA_RESOURCES_DENORM
PL/SQL PackagePA_RESOURCE_UTILS - show dependent code
SynonymPER_ALL_PEOPLE_F
ViewWF_ROLES

APPS.PA_RESOURCE_AVAIL_STAFF_V is not referenced by any database object