VIEW: APPS.PA_ORG_REPORTING_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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