View: PA_C_RES_DETAILS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_C_RES_DETAILS_V

View Text

SELECT PER.PERSON_ID RESOURCE_SOURCE_ID
, PER.FULL_NAME RESOURCE_NAME
, DECODE(PER.CURRENT_EMPLOYEE_FLAG
, 'Y'
, PER.EMPLOYEE_NUMBER
, PER.NPW_NUMBER) RESOURCE_NUMBER
, PER.EMAIL_ADDRESS RESOURCE_EMAIL
, ASSIGN.JOB_ID RESOURCE_JOB_ID
, PJ.NAME AS RESOURCE_JOB_NAME
, PA_JOB_UTILS.GET_JOB_LEVEL(PJ.JOB_ID) RESOURCE_JOB_LEVEL
, PA_JOB_UTILS.GET_JOB_NAME(PJ.JOB_ID
, PJ.JOB_GROUP_ID) MAPPED_JOB_NAME
, PA_JOB_UTILS.GET_JOB_LEVEL(PJ.JOB_ID
, PJ.JOB_GROUP_ID) MAPPED_JOB_LEVEL
, ASSIGN.ORGANIZATION_ID RESOURCE_ORGANIZATION_ID
, HOU.NAME RESOURCE_ORGANIZATION_NAME
, PA_SCHEDULE_UTILS.GET_RES_CALENDAR_NAME(NULL
, SYSDATE
, PER.PERSON_ID) RESOURCE_CALENDAR_NAME
, PER1.FULL_NAME MANAGER_NAME
, PER1.PERSON_ID MANAGER_ID
, PDF.ONLY_CURRENT_LOCATION WORK_IN_CURRENT_LOCATION_ONLY
, PDF.WORK_ANY_LOCATION WORK_IN_ALL_LOCATIONS
, PDF.TRAVEL_REQUIRED TRAVEL_DOMESTICALLY
, PDF.VISIT_INTERNATIONALLY TRAVEL_INTERNATIONALLY
, LOOKUP.MEANING PERSON_TYPE
, PA_RESOURCE_UTILS.GET_PROJECTED_END_DATE(PER.PERSON_ID) PROJECTED_END_DATE
, POV.VENDOR_NAME SUPPLIER_NAME
FROM PER_ASSIGNMENTS_F ASSIGN
, PER_PEOPLE_F PER
, PER_ALL_PEOPLE_F PER1
, PER_JOBS PJ
, HR_ALL_ORGANIZATION_UNITS HOU
, PER_DEPLOYMENT_FACTORS PDF
, HR_LOOKUPS LOOKUP
, PO_VENDORS POV
WHERE ASSIGN.JOB_ID = PJ.JOB_ID (+)
AND ASSIGN.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(ASSIGN.EFFECTIVE_START_DATE)
AND TRUNC(ASSIGN.EFFECTIVE_END_DATE)
AND ASSIGN.PRIMARY_FLAG = 'Y'
AND ASSIGN.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND PER.PERSON_ID = ASSIGN.PERSON_ID
AND ASSIGN.SUPERVISOR_ID = PER1.PERSON_ID (+)
AND PER.PERSON_ID = PDF.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN TRUNC(PER.EFFECTIVE_START_DATE)
AND TRUNC(PER.EFFECTIVE_END_DATE)
AND TRUNC(SYSDATE) BETWEEN TRUNC(PER1.EFFECTIVE_START_DATE(+))
AND TRUNC(PER1.EFFECTIVE_END_DATE(+))
AND LOOKUP.LOOKUP_TYPE = 'PERSON_TYPE'
AND LOOKUP.LOOKUP_CODE = DECODE(PER.CURRENT_EMPLOYEE_FLAG
, 'Y'
, 'EMP'
, 'CWK')
AND POV.VENDOR_ID (+) = ASSIGN.VENDOR_ID

Columns