View: PA_R_EXPENDITURE_ORGS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_R_EXPENDITURE_ORGS_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
, HR_ORGANIZATION_INFORMATION ORG_INFO
WHERE PAORG.ORGANIZATION_ID = HRORG.ORGANIZATION_ID
AND HRORG.ORGANIZATION_ID = ORG_INFO.ORGANIZATION_ID
AND ORG_INFO.ORG_INFORMATION_CONTEXT = 'EXP ORGANIZATION DEFAULTS'
AND PAORG.PA_ORG_USE_TYPE = 'EXPENDITURES'
AND PAORG.INACTIVE_DATE IS NULL
AND (PAORG.ORGANIZATION_ID
, PAORG.ORG_ID) = ( SELECT ORG1.ORGANIZATION_ID
, ORG1.ORG_ID
FROM PA_ALL_ORGANIZATIONS ORG1
WHERE ORG1.PA_ORG_USE_TYPE = 'EXPENDITURES'
AND ORG1.INACTIVE_DATE IS NULL
AND ORG1.ORGANIZATION_ID = PAORG.ORGANIZATION_ID
AND ROWNUM = 1 )

Columns