eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HRFV_ORGANIZATION_HIERARCHIES

Source

View Text - Preformatted


SELECT bgrT.name business_group_name ,RPAD('-',(heir.org_level),'-') || ' ' || org1T.name child_organization_name ,org2T.name parent_organization_name ,stru.name organization_hierarchy_name ,hr_bis.bis_decode_lookup('YES_NO',stru.primary_structure_flag) primary_hierarchy_flag ,heir.org_level organization_hierarchy_level ,per_views_pkg.per_get_organization_employees(heir.organization_id) number_of_employees ,ver.date_from hierarchy_version_start_date ,ver.date_to hierarchy_version_end_date ,ver.version_number organization_hierarchy_version ,heir.business_group_id business_group_id ,heir.organization_id child_organization_id ,stru.organization_structure_id organization_hierarchy_id ,ver.org_structure_version_id org_hierarchy_version_id ,heir.parent_organization_id parent_organization_id FROM hrbv_organization_descendents heir ,hr_all_organization_units_tl org1T ,hr_all_organization_units_tl org2T ,hr_all_organization_units_tl bgrT ,per_org_structure_versions ver ,per_organization_structures stru WHERE heir.org_structure_version_id = ver.org_structure_version_id AND ver.organization_structure_id = stru.organization_structure_id AND heir.organization_id = org1T.organization_id AND org1T.language = userenv('LANG') AND heir.parent_organization_id = org2T.organization_id AND org2T.language = userenv('LANG') AND heir.business_group_id = ver.business_group_id AND ver.business_group_id = stru.business_group_id AND heir.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND heir.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,heir.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, RPAD('-'
, (HEIR.ORG_LEVEL)
, '-') || ' ' || ORG1T.NAME CHILD_ORGANIZATION_NAME
, ORG2T.NAME PARENT_ORGANIZATION_NAME
, STRU.NAME ORGANIZATION_HIERARCHY_NAME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, STRU.PRIMARY_STRUCTURE_FLAG) PRIMARY_HIERARCHY_FLAG
, HEIR.ORG_LEVEL ORGANIZATION_HIERARCHY_LEVEL
, PER_VIEWS_PKG.PER_GET_ORGANIZATION_EMPLOYEES(HEIR.ORGANIZATION_ID) NUMBER_OF_EMPLOYEES
, VER.DATE_FROM HIERARCHY_VERSION_START_DATE
, VER.DATE_TO HIERARCHY_VERSION_END_DATE
, VER.VERSION_NUMBER ORGANIZATION_HIERARCHY_VERSION
, HEIR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HEIR.ORGANIZATION_ID CHILD_ORGANIZATION_ID
, STRU.ORGANIZATION_STRUCTURE_ID ORGANIZATION_HIERARCHY_ID
, VER.ORG_STRUCTURE_VERSION_ID ORG_HIERARCHY_VERSION_ID
, HEIR.PARENT_ORGANIZATION_ID PARENT_ORGANIZATION_ID
FROM HRBV_ORGANIZATION_DESCENDENTS HEIR
, HR_ALL_ORGANIZATION_UNITS_TL ORG1T
, HR_ALL_ORGANIZATION_UNITS_TL ORG2T
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_ORG_STRUCTURE_VERSIONS VER
, PER_ORGANIZATION_STRUCTURES STRU
WHERE HEIR.ORG_STRUCTURE_VERSION_ID = VER.ORG_STRUCTURE_VERSION_ID
AND VER.ORGANIZATION_STRUCTURE_ID = STRU.ORGANIZATION_STRUCTURE_ID
AND HEIR.ORGANIZATION_ID = ORG1T.ORGANIZATION_ID
AND ORG1T.LANGUAGE = USERENV('LANG')
AND HEIR.PARENT_ORGANIZATION_ID = ORG2T.ORGANIZATION_ID
AND ORG2T.LANGUAGE = USERENV('LANG')
AND HEIR.BUSINESS_GROUP_ID = VER.BUSINESS_GROUP_ID
AND VER.BUSINESS_GROUP_ID = STRU.BUSINESS_GROUP_ID
AND HEIR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND HEIR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, HEIR.BUSINESS_GROUP_ID) WITH READ ONLY