VIEW: APPS.HRIBV_ORG_HRCHY

Source

View Text - Preformatted

SELECT ost.name Hierarchy_Name , hr_bis.bis_decode_lookup('YES_NO',ost.primary_structure_flag) Hrchy_Primary_Flag , ost.primary_structure_flag Hrchy_Primary_Flag_Code , osv.version_number Hierarchy_Version , osv.date_from Hierarchy_Version_Date_From , osv.date_to Hierarchy_Version_Date_To , orgT.name Organization_Name , osh.organization_level Organization_Level , sorgT.name Sub_Organization_Name , osh.sub_organization_level Sub_Organization_Level , NVL(osv.date_to, hr_general.end_of_time) Hrchy_Version_Date_To_NN , ost.organization_structure_id Org_Hierarchy_id , osv.org_structure_version_id Org_Hrchy_Version_id , osh.org_business_group_id Org_Business_Group_id , osh.organization_id Organization_ID , osh.sub_org_business_group_id Sub_Org_Business_Group_id , osh.sub_organization_id Sub_Organization_ID FROM per_organization_structures ost , per_org_structure_versions osv ,     hri_org_hrchy_summary osh , hr_all_organization_units_tl orgT , hr_all_organization_units_tl sorgT WHERE ost.organization_structure_id = osv.organization_structure_id AND osv.org_structure_version_id = osh.org_structure_version_id AND osh.organization_id = orgT.organization_id AND orgT.language = USERENV('LANG') AND osh.sub_organization_id = sorgT.organization_id AND sorgT.language = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT OST.NAME HIERARCHY_NAME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, OST.PRIMARY_STRUCTURE_FLAG) HRCHY_PRIMARY_FLAG
, OST.PRIMARY_STRUCTURE_FLAG HRCHY_PRIMARY_FLAG_CODE
, OSV.VERSION_NUMBER HIERARCHY_VERSION
, OSV.DATE_FROM HIERARCHY_VERSION_DATE_FROM
, OSV.DATE_TO HIERARCHY_VERSION_DATE_TO
, ORGT.NAME ORGANIZATION_NAME
, OSH.ORGANIZATION_LEVEL ORGANIZATION_LEVEL
, SORGT.NAME SUB_ORGANIZATION_NAME
, OSH.SUB_ORGANIZATION_LEVEL SUB_ORGANIZATION_LEVEL
, NVL(OSV.DATE_TO
, HR_GENERAL.END_OF_TIME) HRCHY_VERSION_DATE_TO_NN
, OST.ORGANIZATION_STRUCTURE_ID ORG_HIERARCHY_ID
, OSV.ORG_STRUCTURE_VERSION_ID ORG_HRCHY_VERSION_ID
, OSH.ORG_BUSINESS_GROUP_ID ORG_BUSINESS_GROUP_ID
, OSH.ORGANIZATION_ID ORGANIZATION_ID
, OSH.SUB_ORG_BUSINESS_GROUP_ID SUB_ORG_BUSINESS_GROUP_ID
, OSH.SUB_ORGANIZATION_ID SUB_ORGANIZATION_ID
FROM PER_ORGANIZATION_STRUCTURES OST
, PER_ORG_STRUCTURE_VERSIONS OSV
, HRI_ORG_HRCHY_SUMMARY OSH
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL SORGT
WHERE OST.ORGANIZATION_STRUCTURE_ID = OSV.ORGANIZATION_STRUCTURE_ID
AND OSV.ORG_STRUCTURE_VERSION_ID = OSH.ORG_STRUCTURE_VERSION_ID
AND OSH.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND OSH.SUB_ORGANIZATION_ID = SORGT.ORGANIZATION_ID
AND SORGT.LANGUAGE = USERENV('LANG') WITH READ ONLY