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