[Home] [Help]
View: PA_RESOURCE_DETAILS_V
View Text
SELECT DENORM.PERSON_ID RESOURCE_SOURCE_ID
, DENORM.RESOURCE_ID
, DENORM.RESOURCE_NAME
, DENORM.RESOURCE_EFFECTIVE_START_DATE
, DENORM.RESOURCE_EFFECTIVE_END_DATE
, PA_RESOURCE_UTILS.GET_ORG_PRIM_CONTACT_ID(DENORM.RESOURCE_ORGANIZATION_ID
, 'PA_PRM_RES_PRMRY_CONTACT') STAFFING_MANAGER_ID
, PA_RESOURCE_UTILS.GET_ORG_PRIM_CONTACT_NAME(DENORM.RESOURCE_ORGANIZATION_ID
, 'PA_PRM_RES_PRMRY_CONTACT') STAFFING_MANAGER_NAME
, DENORM.MANAGER_NAME
, DENORM.MANAGER_ID
FROM PA_RESOURCES_DENORM DENORM
Columns
Name |
RESOURCE_SOURCE_ID |
RESOURCE_ID |
RESOURCE_NAME |
START_DATE |
END_DATE |
STAFFING_MANAGER_ID |
STAFFING_MANAGER_NAME |
RESOURCE_MANAGER_NAME |
RESOURCE_MANAGER_ID |