View: PA_MANAGERS_V

Product:	PA - Projects
Description:	PA_MANAGERS_V is a view that shows manager details for all primary active assignments.
Implementation/DBA Data:	APPS.PA_MANAGERS_V

View Text

SELECT PER.FIRST_NAME
, PER.LAST_NAME
, PER.FULL_NAME
, ASSIGN.SUPERVISOR_ID
, HRORG.NAME
, ASSIGN2.ORGANIZATION_ID
, ASSIGN2.EFFECTIVE_START_DATE
, ASSIGN2.EFFECTIVE_END_DATE
, PER.EMAIL_ADDRESS
, FLV.MEANING
FROM PER_ASSIGNMENTS_F ASSIGN
, PER_ASSIGNMENT_STATUS_TYPES AST
, PER_PEOPLE_X PER
, PER_ASSIGNMENTS_F ASSIGN2
, HR_ORGANIZATION_UNITS HRORG
, FND_LOOKUP_VALUES FLV
WHERE ASSIGN.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
AND AST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN'
, 'ACTIVE_CWK')
AND ASSIGN.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND ASSIGN.JOB_ID IS NOT NULL
AND ASSIGN.PRIMARY_FLAG = 'Y'
AND NVL(ASSIGN.EFFECTIVE_END_DATE
, SYSDATE) >= TRUNC(SYSDATE)
AND ASSIGN.SUPERVISOR_ID = PER.PERSON_ID
AND ASSIGN.SUPERVISOR_ID = ASSIGN2.PERSON_ID
AND ASSIGN2.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
AND ASSIGN2.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND ASSIGN2.JOB_ID IS NOT NULL
AND ASSIGN2.PRIMARY_FLAG = 'Y'
AND NVL(ASSIGN2.EFFECTIVE_END_DATE
, SYSDATE) >= TRUNC(SYSDATE)
AND ASSIGN2.ORGANIZATION_ID = HRORG.ORGANIZATION_ID
AND FLV.VIEW_APPLICATION_ID=3
AND FLV.LOOKUP_TYPE = 'PERSON_TYPE'
AND FLV.LANGUAGE = USERENV('LANG')
AND FLV.LOOKUP_CODE=DECODE(PER.CURRENT_EMPLOYEE_FLAG
, 'Y'
, 'EMP'
, 'CWK')

Columns