View: PA_R_HIERARCHIES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_R_HIERARCHIES_V

View Text

SELECT IMP.EXP_ORG_STRUCTURE_ID ORG_STRUCTURE_ID
, IMP.EXP_ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID
, POS.NAME ORG_STRUCTURE_NAME
, POSV.VERSION_NUMBER VERSION_NUMBER
, PAORG.ORGANIZATION_ID
, PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME(PAORG.ORGANIZATION_ID)
, 'EXPENDITURE' STRUCTURE_TYPE
, IMP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, IMP.ORG_ID ORG_ID
, PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME(IMP.ORG_ID) OU_NAME
FROM PA_IMPLEMENTATIONS_ALL IMP
, PER_ORG_STRUCTURE_VERSIONS POSV
, PER_ORGANIZATION_STRUCTURES POS
, PA_ALL_ORGANIZATIONS PAORG
WHERE IMP.EXP_ORG_STRUCTURE_VERSION_ID = POSV.ORG_STRUCTURE_VERSION_ID
AND POSV.ORGANIZATION_STRUCTURE_ID = POS.ORGANIZATION_STRUCTURE_ID
AND IMP.ORG_ID = PAORG.ORG_ID
AND PAORG.PA_ORG_USE_TYPE = 'EXPENDITURES'
AND PAORG.INACTIVE_DATE IS NULL UNION SELECT IMP.PROJ_ORG_STRUCTURE_ID ORG_STRUCTURE_ID
, IMP.PROJ_ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID
, POS.NAME ORG_STRUCTURE_NAME
, POSV.VERSION_NUMBER VERSION_NUMBER
, PAORG.ORGANIZATION_ID
, PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME(PAORG.ORGANIZATION_ID)
, 'PROJECT' STRUCTURE_TYPE
, IMP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, IMP.ORG_ID ORG_ID
, PA_RESOURCE_UTILS.GET_ORGANIZATION_NAME(IMP.ORG_ID) OU_NAME
FROM PA_IMPLEMENTATIONS_ALL IMP
, PER_ORG_STRUCTURE_VERSIONS POSV
, PER_ORGANIZATION_STRUCTURES POS
, PA_ALL_ORGANIZATIONS PAORG
WHERE IMP.PROJ_ORG_STRUCTURE_VERSION_ID = POSV.ORG_STRUCTURE_VERSION_ID
AND POSV.ORGANIZATION_STRUCTURE_ID = POS.ORGANIZATION_STRUCTURE_ID
AND IMP.ORG_ID = PAORG.ORG_ID
AND PAORG.PA_ORG_USE_TYPE = 'PROJECTS'
AND PAORG.INACTIVE_DATE IS NULL

Columns