View: PA_ORG_REPORTING_VIEW

Product:	PA - Projects
Description:	View used in reports to report all organizations below a start organization
Implementation/DBA Data:	APPS.PA_ORG_REPORTING_VIEW

View Text

SELECT ORG_ID
, NAME
FROM ( SELECT E.ORGANIZATION_ID_CHILD ORG_ID
FROM PER_ORG_STRUCTURE_ELEMENTS E START WITH (E.ORGANIZATION_ID_PARENT
, E.ORG_STRUCTURE_VERSION_ID) = ( SELECT S.START_ORGANIZATION_ID
, IMP.ORG_STRUCTURE_VERSION_ID
FROM PA_ORG_REPORTING_SESSIONS S
, PA_IMPLEMENTATIONS IMP
WHERE S.SESSION_ID = USERENV ( 'SESSIONID' ) ) CONNECT BY PRIOR E.ORGANIZATION_ID_CHILD = E.ORGANIZATION_ID_PARENT
AND PRIOR E.ORG_STRUCTURE_VERSION_ID = E.ORG_STRUCTURE_VERSION_ID UNION SELECT START_ORGANIZATION_ID
FROM PA_ORG_REPORTING_SESSIONS ORS
WHERE ORS.SESSION_ID = USERENV ( 'SESSIONID' ) ) V
, HR_ALL_ORGANIZATION_UNITS_TL H
WHERE V.ORG_ID = H.ORGANIZATION_ID
AND USERENV('LANG') = H.LANGUAGE

Columns