View: PA_CANDIDATE_LOG_AMG_V

Product:	PA - Projects
Description:	This view shows all candidate reviews.
Implementation/DBA Data:	APPS.PA_CANDIDATE_LOG_AMG_V

View Text

SELECT PCR.CANDIDATE_REVIEW_ID
, CAND.CANDIDATE_ID
, RES.RESOURCE_NAME
, CAND.ASSIGNMENT_ID
, CAND.STATUS_CODE
, PS.PROJECT_STATUS_NAME
, PS.PROJECT_SYSTEM_STATUS_CODE
, PCR.CHANGE_REASON_CODE
, PCR.REVIEW_COMMENTS
FROM PA_CANDIDATES CAND
, PA_RESOURCES_DENORM RES
, PA_PROJECT_STATUSES PS
, PA_CANDIDATE_REVIEWS PCR
WHERE CAND.RESOURCE_ID = RES.RESOURCE_ID
AND RES.RESOURCE_EFFECTIVE_START_DATE = ( SELECT MAX(RES2.RESOURCE_EFFECTIVE_START_DATE)
FROM PA_RESOURCES_DENORM RES2
WHERE RES2.RESOURCE_ID = RES.RESOURCE_ID)
AND CAND.STATUS_CODE = PS.PROJECT_STATUS_CODE
AND PS.STATUS_TYPE = 'CANDIDATE'
AND CAND.CANDIDATE_ID = PCR.CANDIDATE_ID

Columns