[Home] [Help]
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
Name |
RESOURCE_ID |
PERSON_ID |
FULL_NAME |
FIRST_NAME |
LAST_NAME |
MIDDLE_NAMES |
PERSON_TYPE |
RESOURCE_NUMBER |
ORGANIZATION_ID |
ORGANIZATION_NAME |
START_DATE |
END_DATE |