View: PER_ORG_MANAGER_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.PER_ORG_MANAGER_V

View Text

SELECT PPF.PERSON_ID
, PPF.FULL_NAME
, ORG.ORGANIZATION_ID
, ORG.BUSINESS_GROUP_ID
, ORG_TL.NAME
, FND_DATE.CANONICAL_TO_DATE(ORG_INFO2.ORG_INFORMATION3)
, FND_DATE.CANONICAL_TO_DATE(ORG_INFO2.ORG_INFORMATION4)
, ORG_INFO2.ORG_INFORMATION_ID
, ORG_INFO2.OBJECT_VERSION_NUMBER
FROM HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORG_TL
, HR_ORGANIZATION_INFORMATION ORG_INFO2
, PER_ALL_PEOPLE_F PPF
, FND_SESSIONS FND
WHERE ORG_INFO2.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ORG_INFO2.ORG_INFORMATION_CONTEXT = 'ORGANIZATION NAME ALIAS'
AND ORG_INFO2.ORG_INFORMATION2 = TO_CHAR(PPF.PERSON_ID(+))
AND ORG.ORGANIZATION_ID = ORG_TL.ORGANIZATION_ID
AND ORG_TL.LANGUAGE = USERENV('LANG')
AND EXISTS (SELECT NULL
FROM HR_ORG_INFO_TYPES_BY_CLASS OITBC
, HR_ORGANIZATION_INFORMATION ORG_INFO
WHERE ORG_INFO.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ORG_INFO.ORG_INFORMATION_CONTEXT = 'CLASS'
AND ORG_INFO.ORG_INFORMATION2 = 'Y'
AND OITBC.ORG_CLASSIFICATION = ORG_INFO.ORG_INFORMATION1
AND OITBC.ORG_INFORMATION_TYPE = 'ORGANIZATION NAME ALIAS')
AND (DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, ORG.ORGANIZATION_ID))='TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, ORG.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = ORG.BUSINESS_GROUP_ID OR DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F'
, PPF.PERSON_ID
, PPF.PERSON_TYPE_ID
, PPF.EMPLOYEE_NUMBER
, PPF.APPLICANT_NUMBER))= 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, PPF.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID)=PPF.BUSINESS_GROUP_ID)
AND FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN NVL(PPF.EFFECTIVE_START_DATE
, FND.EFFECTIVE_DATE)
AND NVL(PPF.EFFECTIVE_END_DATE
, FND.EFFECTIVE_DATE)

Columns