View: PA_ORGANIZATIONS_EXP_ALL_BG_V

Product:	PA - Projects
Description:	View that shows all expenditure organizations for a buiseness group.
Implementation/DBA Data:	APPS.PA_ORGANIZATIONS_EXP_ALL_BG_V

View Text

SELECT DISTINCT HRORG.ORGANIZATION_ID
, HRORG.BUSINESS_GROUP_ID
, HRORG.NAME
, HRORG.DATE_FROM
, HRORG.DATE_TO
FROM HR_ORGANIZATION_UNITS HRORG
, PA_ALL_ORGANIZATIONS PAORG
, PA_IMPLEMENTATIONS IMP
, PA_IMPLEMENTATIONS_ALL IMPALL
WHERE PAORG.ORGANIZATION_ID = HRORG.ORGANIZATION_ID
AND PAORG.PA_ORG_USE_TYPE = 'EXPENDITURES'
AND PAORG.ORG_ID = IMPALL.ORG_ID
AND IMP.BUSINESS_GROUP_ID = IMPALL.BUSINESS_GROUP_ID

Columns