View: PA_ORG_HIERARCHIES_V

Product:	PA - Projects
Description:	PA_ORG_HIERARCHIES_V is a view that identifies the organization structures available base on if the using global cross charging or not.- Retrofitted
Implementation/DBA Data:	APPS.PA_ORG_HIERARCHIES_V

View Text

SELECT DISTINCT S.NAME
, S.ORGANIZATION_STRUCTURE_ID
FROM PER_ORGANIZATION_STRUCTURES S
WHERE ((S.BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='N') OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE ='Y')
AND EXISTS ( SELECT NULL
FROM PER_ORG_STRUCTURE_VERSIONS V
WHERE S.ORGANIZATION_STRUCTURE_ID = V.ORGANIZATION_STRUCTURE_ID )

Columns