View: PA_ORGANIZATIONS_PROJECT_V

Product:	PA - Projects
Description:	View of the organizations that can be used as owning organizations of projects and tasks
Implementation/DBA Data:	APPS.PA_ORGANIZATIONS_PROJECT_V

View Text

SELECT HRORG.ORGANIZATION_ID
, HRORG.BUSINESS_GROUP_ID
, HRORG.NAME
, HRORG.DATE_FROM
, HRORG.DATE_TO
, 'Y'
, ORG_ID
FROM HR_ORGANIZATION_UNITS HRORG
, PA_ALL_ORGANIZATIONS PAORG
WHERE PAORG.ORGANIZATION_ID = HRORG.ORGANIZATION_ID
AND PAORG.PA_ORG_USE_TYPE = 'PROJECTS'
AND PAORG.INACTIVE_DATE IS NULL
AND ( (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL
AND MO_GLOBAL.CHECK_ACCESS(PAORG.ORG_ID) = 'Y') OR (MO_GLOBAL.GET_CURRENT_ORG_ID IS NOT NULL
AND PAORG.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID ) )

Columns