[Home] [Help]
View: PA_PROJ_ORG_STRUCTURES_V
Product: | PA - Projects |
Description: | This view displays the implementation-defined Project organization hierarchy |
Implementation/DBA Data: |
APPS.PA_PROJ_ORG_STRUCTURES_V
|
View Text
SELECT IMP.ORG_ID
, IMP.BUSINESS_GROUP_ID
, PEOS.ORGANIZATION_ID_CHILD
, PEOS.ORGANIZATION_ID_PARENT
, ORG1.NAME
, ORG2T.NAME
, PEOS.ORG_STRUCTURE_VERSION_ID
, 'Y'
FROM HR_ORGANIZATION_UNITS ORG1
, HR_ORG_UNITS_NO_JOIN ORG2
, HR_ALL_ORGANIZATION_UNITS_TL ORG2T
, PA_IMPLEMENTATIONS IMP
, PER_ORG_STRUCTURE_ELEMENTS PEOS
WHERE PEOS.ORG_STRUCTURE_VERSION_ID = IMP.PROJ_ORG_STRUCTURE_VERSION_ID
AND PEOS.ORGANIZATION_ID_CHILD = ORG1.ORGANIZATION_ID
AND PEOS.ORGANIZATION_ID_PARENT = ORG2.ORGANIZATION_ID (+)
AND ORG2.ORGANIZATION_ID = ORG2T.ORGANIZATION_ID (+)
AND DECODE(ORG2T.ORGANIZATION_ID
, NULL
, '1'
, ORG2T.LANGUAGE) = DECODE(ORG2T.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND EXISTS (SELECT 'X'
FROM HR_ORGANIZATION_INFORMATION INFO
WHERE ORG1.ORGANIZATION_ID = INFO.ORGANIZATION_ID
AND INFO.ORG_INFORMATION1 = 'PA_PROJECT_ORG'
AND INFO.ORG_INFORMATION_CONTEXT||'' = 'CLASS'
AND INFO.ORG_INFORMATION2 = 'Y')
AND PEOS.ORGANIZATION_ID_CHILD IN /*IN PROJECT ORG HIERARCHY */ (SELECT SE.ORGANIZATION_ID_CHILD
FROM PER_ORG_STRUCTURE_ELEMENTS SE
WHERE ORG_STRUCTURE_VERSION_ID = IMP.PROJ_ORG_STRUCTURE_VERSION_ID CONNECT BY PRIOR SE.ORGANIZATION_ID_CHILD = SE.ORGANIZATION_ID_PARENT
AND ORG_STRUCTURE_VERSION_ID = IMP.PROJ_ORG_STRUCTURE_VERSION_ID START WITH SE.ORGANIZATION_ID_PARENT = IMP.PROJ_START_ORG_ID
AND ORG_STRUCTURE_VERSION_ID = IMP.PROJ_ORG_STRUCTURE_VERSION_ID UNION SELECT IMP.PROJ_START_ORG_ID
FROM SYS.DUAL )
Columns
Name |
ORG_ID |
BUSINESS_GROUP_ID |
ORGANIZATION_ID |
PARENT_ORG_ID |
ORGANIZATION_NAME |
PARENT_ORG_NAME |
ORG_STRUCTURE_VERSION_ID |
PROJECT_ORG_FLAG |