View: PA_ALL_ORG_V

Product:	PA - Projects
Description:	PA_ALL_ORG_V is a view that shows organizations across business broups for searching projects in SSWA
Implementation/DBA Data:	APPS.PA_ALL_ORG_V

View Text

SELECT DISTINCT ORG.ORGANIZATION_ID ORGANIZATION_ID
, PA_EXPENDITURES_UTILS.GETORGTLNAME(ORG.ORGANIZATION_ID) NAME
, BG.NAME BUSINESS_GROUP_NAME
FROM PA_ALL_ORGANIZATIONS ORG
, PER_BUSINESS_GROUPS BG
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE ORG.INACTIVE_DATE IS NULL
AND ORG.PA_ORG_USE_TYPE IN ('EXPENDITURES'
, 'PROJECTS')
AND ORG.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND HAOU.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID
AND ( ( PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'N'
AND FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') = HAOU.BUSINESS_GROUP_ID) OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'Y')

Columns