View: PA_RESOURCES_AMG_V

Product:	PA - Projects
Description:	This view shows all the resources that can be added as candidates or assigned to a requirement.
Implementation/DBA Data:	APPS.PA_RESOURCES_AMG_V

View Text

SELECT RES.RESOURCE_ID
, RES.RESOURCE_SOURCE_ID
, RES.RESOURCE_NAME
, RES.RESOURCE_FIRST_NAME
, RES.RESOURCE_LAST_NAME
, RES.RESOURCE_MIDDLE_NAMES
, LKP.MEANING
, RES.RESOURCE_NUMBER
, RES.RESOURCE_ORGANIZATION_ID
, RES.RESOURCE_ORGANIZATION_NAME
, RES.ASSIGNMENT_START_DATE
, RES.ASSIGNMENT_END_DATE
FROM PA_C_ELIG_RESOURCE_V RES
, PA_LOOKUPS LKP
WHERE LKP.LOOKUP_TYPE = 'PA_PERSON_TYPE'
AND RES.PERSON_TYPE = LKP.LOOKUP_CODE

Columns