eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	PA.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

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
FROM APPS.PA_RESOURCE_AVAIL_STAFF_V;

Dependencies

[top of page]

APPS.PA_RESOURCE_AVAIL_STAFF_V references the following:

APPS: FND_GRANTS; FND_MENUS; FND_OBJECTS; HR_ALL_ORGANIZATION_UNITS_TL; PA_RESOURCES_DENORM; PA_RESOURCE_UTILS - show dependent code; PER_ALL_PEOPLE_F; WF_ROLES

APPS.PA_RESOURCE_AVAIL_STAFF_V is not referenced by any database object