VIEW: APPS.PJI_DIS_ORG_ROHRCHY_V

Source

View Text - Preformatted

SELECT sup.organization_id, hou1.name, sup.sub_organization_id, hou2.name, sub.sub_organization_id, hou3.name, sup.organization_level, sup.sub_organization_level, sub.sub_organization_level, sup.sub_organization_level - sup.organization_level, sub.sub_organization_level - sup.organization_level, sub.sub_organization_level - sub.organization_level FROM pji_org_denorm sup, pji_org_denorm sub, hr_all_organization_units_tl hou1, hr_all_organization_units_tl hou2, hr_all_organization_units_tl hou3 WHERE sup.sub_organization_id = sub.organization_id AND sup.organization_id = hou1.organization_id AND sup.sub_organization_id = hou2.organization_id AND sub.sub_organization_id = hou3.organization_id AND hou1.LANGUAGE = USERENV('LANG') AND hou2.LANGUAGE = USERENV('LANG') AND hou3.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT SUP.ORGANIZATION_ID
, HOU1.NAME
, SUP.SUB_ORGANIZATION_ID
, HOU2.NAME
, SUB.SUB_ORGANIZATION_ID
, HOU3.NAME
, SUP.ORGANIZATION_LEVEL
, SUP.SUB_ORGANIZATION_LEVEL
, SUB.SUB_ORGANIZATION_LEVEL
, SUP.SUB_ORGANIZATION_LEVEL - SUP.ORGANIZATION_LEVEL
, SUB.SUB_ORGANIZATION_LEVEL - SUP.ORGANIZATION_LEVEL
, SUB.SUB_ORGANIZATION_LEVEL - SUB.ORGANIZATION_LEVEL
FROM PJI_ORG_DENORM SUP
, PJI_ORG_DENORM SUB
, HR_ALL_ORGANIZATION_UNITS_TL HOU1
, HR_ALL_ORGANIZATION_UNITS_TL HOU2
, HR_ALL_ORGANIZATION_UNITS_TL HOU3
WHERE SUP.SUB_ORGANIZATION_ID = SUB.ORGANIZATION_ID
AND SUP.ORGANIZATION_ID = HOU1.ORGANIZATION_ID
AND SUP.SUB_ORGANIZATION_ID = HOU2.ORGANIZATION_ID
AND SUB.SUB_ORGANIZATION_ID = HOU3.ORGANIZATION_ID
AND HOU1.LANGUAGE = USERENV('LANG')
AND HOU2.LANGUAGE = USERENV('LANG')
AND HOU3.LANGUAGE = USERENV('LANG')