VIEW: APPS.PA_ORG_HIERARCHIES_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )