View: PJI_OPERATING_UNITS_V

Product:	PJI - Project Intelligence
Description:	This is an internal summarization view.
Implementation/DBA Data:	APPS.PJI_OPERATING_UNITS_V

View Text

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)

Columns