VIEW: APPS.PJI_OPERATING_UNITS_V

Source

View Text - Preformatted

SELECT hrorg.organization_id id , hrorg.name value FROM hr_all_organization_units_tl hrorg , pa_implementations_all paimp , per_organization_list sec , per_security_profiles prof WHERE paimp.org_id = hrorg.organization_id AND hrorg.LANGUAGE = USERENV('LANG') AND hrorg.organization_id = sec.organization_id (+) AND sec.security_profile_id(+) = fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') AND fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') IS NOT NULL AND prof.security_profile_id = fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL') AND ( prof.view_all_organizations_flag = 'Y' OR sec.organization_id IS NOT NULL)

View Text - HTML Formatted

SELECT HRORG.ORGANIZATION_ID ID
, HRORG.NAME VALUE
FROM HR_ALL_ORGANIZATION_UNITS_TL HRORG
, PA_IMPLEMENTATIONS_ALL PAIMP
, PER_ORGANIZATION_LIST SEC
, PER_SECURITY_PROFILES PROF
WHERE PAIMP.ORG_ID = HRORG.ORGANIZATION_ID
AND HRORG.LANGUAGE = USERENV('LANG')
AND HRORG.ORGANIZATION_ID = SEC.ORGANIZATION_ID (+)
AND SEC.SECURITY_PROFILE_ID(+) = FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL')
AND FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL') IS NOT NULL
AND PROF.SECURITY_PROFILE_ID = FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL')
AND ( PROF.VIEW_ALL_ORGANIZATIONS_FLAG = 'Y' OR SEC.ORGANIZATION_ID IS NOT NULL)