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_RESOURCES_AMG_V

Object Details

Object Name:	PA_RESOURCES_AMG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_RESOURCES_AMG_V
Subobject Name:
Status:	VALID

View Type

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

This view shows all the resources that can be added as candidates or assigned to a requirement.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER	(15)		The identifier of the resource in Projects
PERSON_ID	NUMBER	(10)		The person identifier of the resource
FULL_NAME	VARCHAR2	(4000)		The full name of the resource
FIRST_NAME	VARCHAR2	(150)		The first name of the resource
LAST_NAME	VARCHAR2	(150)		The last name of the resource
MIDDLE_NAMES	VARCHAR2	(60)		The middle name of the resource
PERSON_TYPE	VARCHAR2	(80)	Yes	The person type of the resource (employee or contingent worker)
RESOURCE_NUMBER	VARCHAR2	(30)		The identifier of the person from HR (employee number or contingent worker number)
ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization to which the resource belongs
ORGANIZATION_NAME	VARCHAR2	(240)		The name of the organization to which the resource belongs
START_DATE	DATE			The start date of the resource
END_DATE	DATE			The end date of the resource

Query Text

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


SELECT RESOURCE_ID
,      PERSON_ID
,      FULL_NAME
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAMES
,      PERSON_TYPE
,      RESOURCE_NUMBER
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      START_DATE
,      END_DATE
FROM APPS.PA_RESOURCES_AMG_V;

Dependencies

[top of page]

APPS.PA_RESOURCES_AMG_V references the following:

APPS: HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PA_C_ELIG_RESOURCE_V; PA_LOOKUPS; PA_RESOURCE_UTILS - show dependent code

APPS.PA_RESOURCES_AMG_V is not referenced by any database object