DBA Data[Home] [Help]

VIEW: HR.PER_WPM_PLAN_HIERARCHY#

Source

View Text - Preformatted

select WPM_PLAN_HIERARCHY_ID WPM_PLAN_HIERARCHY_ID, PLAN_ID PLAN_ID, SUPERVISOR_PERSON_ID SUPERVISOR_PERSON_ID, SUPERVISOR_NAME SUPERVISOR_NAME, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID, EMPLOYEE_NAME EMPLOYEE_NAME, LEVEL_NUM LEVEL_NUM, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "HR"."PER_WPM_PLAN_HIERARCHY"
View Text - HTML Formatted

SELECT WPM_PLAN_HIERARCHY_ID WPM_PLAN_HIERARCHY_ID
, PLAN_ID PLAN_ID
, SUPERVISOR_PERSON_ID SUPERVISOR_PERSON_ID
, SUPERVISOR_NAME SUPERVISOR_NAME
, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID
, EMPLOYEE_NAME EMPLOYEE_NAME
, LEVEL_NUM LEVEL_NUM
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "HR"."PER_WPM_PLAN_HIERARCHY"