VIEW: APPS.PER_ORG_MANAGER_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)