View: PA_ORGANIZATIONS_EXPEND_V

Product:	PA - Projects
Description:	Organizations that can be used as expenditure organization in expenditure entry
Implementation/DBA Data:	APPS.PA_ORGANIZATIONS_EXPEND_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 = 'EXPENDITURES'
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