View: HRFV_SUPERVISORS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_SUPERVISORS

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, ASS.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, SUP.FULL_NAME SUPERVISOR_NAME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, NVL(SUP.CURRENT_EMPLOYEE_FLAG
, NULL)) SUPERVISOR_CURRENT_EMP_FLAG
, SUP.INTERNAL_LOCATION SUPERVISOR_INTERNAL_LOCATION
, SUP.MAILSTOP SUPERVISOR_MAILSTOP
, SUP.EMAIL_ADDRESS SUPERVISOR_EMAIL_ADDRESS
, ORGT.NAME ORGANIZATION_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, '_DF:PER:PER_PEOPLE:PEO'
, '_DF:PER:PER_PEOPLE:SUP'
, ASS.ASSIGNMENT_ID ASSIGNMENT_ID
, ASS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASS.PERSON_ID PERSON_ID
, ASS.SUPERVISOR_ID SUPERVISOR_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_LOCATIONS_ALL_TL LOCT
, PER_ASSIGNMENTS_X ASS
, PER_ALL_PEOPLE_F SUP
, PER_PEOPLE_X PEO
WHERE PEO.PERSON_ID = ASS.PERSON_ID
AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
AND PEO.EMPLOYEE_NUMBER IS NOT NULL
AND ASS.ASSIGNMENT_TYPE = 'E'
AND ASS.SUPERVISOR_ID = SUP.PERSON_ID (+)
AND ASS.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND ASS.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND TRUNC(SYSDATE) BETWEEN SUP.EFFECTIVE_START_DATE
AND SUP.EFFECTIVE_END_DATE
AND ASS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASS.BUSINESS_GROUP_ID) WITH READ ONLY

Columns