[Home] [Help]
View: PA_REP_ALL_REP_ORG_V
Product: | PA - Projects |
Description: | PA_REP_ALL_REP_ORG_V is a view that lists all reporting Hierarchy for and OU |
Implementation/DBA Data: |
APPS.PA_REP_ALL_REP_ORG_V
|
View Text
SELECT POHD.PARENT_ORGANIZATION_ID
, HR1.NAME
, POHD.CHILD_ORGANIZATION_ID
, HR2.NAME
FROM PA_ORG_HIERARCHY_DENORM POHD
, PA_IMPLEMENTATIONS IMP
, HR_ALL_ORGANIZATION_UNITS_TL HR1
, HR_ALL_ORGANIZATION_UNITS_TL HR2
WHERE POHD.PA_ORG_USE_TYPE = 'REPORTING'
AND POHD.ORG_ID = IMP.ORG_ID
AND POHD.ORG_HIERARCHY_VERSION_ID = IMP.ORG_STRUCTURE_VERSION_ID
AND POHD.PARENT_ORGANIZATION_ID = HR1.ORGANIZATION_ID
AND HR1.LANGUAGE = USERENV('LANG')
AND POHD.CHILD_ORGANIZATION_ID = HR2.ORGANIZATION_ID
AND HR2.LANGUAGE = USERENV('LANG')
Columns
Name |
PARENT_ORGANIZATION_ID |
PARENT_ORG_NAME |
CHILD_ORGANIZATION_ID |
CHILD_ORG_NAME |