VIEW: APPS.HRI_CS_ORGHRO_V

Source

View Text - Preformatted

SELECT ohs_sup.organization_level sup_org_absolute_level , ohs_sup.sub_organization_level sub_org_absolute_level , ohs_sup.sub_organization_level - ohs_sup.organization_level sub_org_relative_level , ohs_sub.sub_organization_level subro_org_relative_level , ohs_sub.sub_organization_level - ohs_sup.organization_level subro_sup_org_relative_level , ohs_sub.sub_organization_level - ohs_sub.organization_level subro_sub_org_relative_level , ohs_sup.org_structure_version_id org_hierarchy_version_id , ohs_sup.organization_id sup_organization_id , ohs_sup.sub_organization_id sub_organization_id , ohs_sub.sub_organization_id subro_organization_id , ohs_sup.org_business_group_id sup_org_business_group_id , ohs_sup.sub_org_business_group_id sub_org_business_group_id , ohs_sub.sub_org_business_group_id subro_org_business_group_id , GREATEST(ohs_sup.last_update_date ,ohs_sub.last_update_date) last_change_date FROM hri_org_hrchy_summary ohs_sup , hri_org_hrchy_summary ohs_sub WHERE ohs_sup.org_structure_version_id = ohs_sub.org_structure_version_id AND ohs_sup.sub_organization_id = ohs_sub.organization_id WITH READ ONLY

View Text - HTML Formatted

SELECT OHS_SUP.ORGANIZATION_LEVEL SUP_ORG_ABSOLUTE_LEVEL
, OHS_SUP.SUB_ORGANIZATION_LEVEL SUB_ORG_ABSOLUTE_LEVEL
, OHS_SUP.SUB_ORGANIZATION_LEVEL - OHS_SUP.ORGANIZATION_LEVEL SUB_ORG_RELATIVE_LEVEL
, OHS_SUB.SUB_ORGANIZATION_LEVEL SUBRO_ORG_RELATIVE_LEVEL
, OHS_SUB.SUB_ORGANIZATION_LEVEL - OHS_SUP.ORGANIZATION_LEVEL SUBRO_SUP_ORG_RELATIVE_LEVEL
, OHS_SUB.SUB_ORGANIZATION_LEVEL - OHS_SUB.ORGANIZATION_LEVEL SUBRO_SUB_ORG_RELATIVE_LEVEL
, OHS_SUP.ORG_STRUCTURE_VERSION_ID ORG_HIERARCHY_VERSION_ID
, OHS_SUP.ORGANIZATION_ID SUP_ORGANIZATION_ID
, OHS_SUP.SUB_ORGANIZATION_ID SUB_ORGANIZATION_ID
, OHS_SUB.SUB_ORGANIZATION_ID SUBRO_ORGANIZATION_ID
, OHS_SUP.ORG_BUSINESS_GROUP_ID SUP_ORG_BUSINESS_GROUP_ID
, OHS_SUP.SUB_ORG_BUSINESS_GROUP_ID SUB_ORG_BUSINESS_GROUP_ID
, OHS_SUB.SUB_ORG_BUSINESS_GROUP_ID SUBRO_ORG_BUSINESS_GROUP_ID
, GREATEST(OHS_SUP.LAST_UPDATE_DATE
, OHS_SUB.LAST_UPDATE_DATE) LAST_CHANGE_DATE
FROM HRI_ORG_HRCHY_SUMMARY OHS_SUP
, HRI_ORG_HRCHY_SUMMARY OHS_SUB
WHERE OHS_SUP.ORG_STRUCTURE_VERSION_ID = OHS_SUB.ORG_STRUCTURE_VERSION_ID
AND OHS_SUP.SUB_ORGANIZATION_ID = OHS_SUB.ORGANIZATION_ID WITH READ ONLY