View: PA_XCHARGE_PROJECT_ORGS_V

Product:	PA - Projects
Description:	View to list all project owning Organizations associated with the operating units that are Cross chargeable from the current operating unit
Implementation/DBA Data:	APPS.PA_XCHARGE_PROJECT_ORGS_V

View Text

SELECT DISTINCT ORG.ORGANIZATION_ID
, ORG.BUSINESS_GROUP_ID
, ORG.NAME
, ORG.DATE_FROM
, ORG.DATE_TO
, 'Y'
FROM HR_ORGANIZATION_UNITS ORG
, PA_ALL_ORGANIZATIONS PAO WHERE(( ORG.BUSINESS_GROUP_ID =PA_UTILS.BUSINESS_GROUP_ID
AND PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='N') OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE='Y')
AND ORG.ORGANIZATION_ID = PAO.ORGANIZATION_ID
AND PAO.PA_ORG_USE_TYPE = 'PROJECTS'
AND PAO.INACTIVE_DATE IS NULL

Columns