DBA Data[Home] [Help]

VIEW: HR.PER_ORG_HRCHY_SUMMARY#

Source

View Text - Preformatted

select ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID, ORG_BUSINESS_GROUP_ID ORG_BUSINESS_GROUP_ID, ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_LEVEL ORGANIZATION_LEVEL, SUB_ORG_BUSINESS_GROUP_ID SUB_ORG_BUSINESS_GROUP_ID, SUB_ORGANIZATION_ID SUB_ORGANIZATION_ID, SUB_ORGANIZATION_LEVEL SUB_ORGANIZATION_LEVEL, SUB_ORG_RELATIVE_LEVEL SUB_ORG_RELATIVE_LEVEL, LAST_PTNTL_CHANGE LAST_PTNTL_CHANGE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "HR"."PER_ORG_HRCHY_SUMMARY"
View Text - HTML Formatted

SELECT ORGANIZATION_STRUCTURE_ID ORGANIZATION_STRUCTURE_ID
, ORG_BUSINESS_GROUP_ID ORG_BUSINESS_GROUP_ID
, ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_LEVEL ORGANIZATION_LEVEL
, SUB_ORG_BUSINESS_GROUP_ID SUB_ORG_BUSINESS_GROUP_ID
, SUB_ORGANIZATION_ID SUB_ORGANIZATION_ID
, SUB_ORGANIZATION_LEVEL SUB_ORGANIZATION_LEVEL
, SUB_ORG_RELATIVE_LEVEL SUB_ORG_RELATIVE_LEVEL
, LAST_PTNTL_CHANGE LAST_PTNTL_CHANGE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "HR"."PER_ORG_HRCHY_SUMMARY"