[Home] [Help]
View: CHV_PLANNERS_VAL_V
View Text
SELECT HRE.FULL_NAME
, HRE.EMPLOYEE_NUM
, HRE.LOCATION_ID
, MTP.PLANNER_CODE
, MTP.EMPLOYEE_ID PLANNER_ID
FROM MTL_PLANNERS MTP
, HR_EMPLOYEES_CURRENT_V HRE
WHERE MTP.EMPLOYEE_ID = HRE.EMPLOYEE_ID
AND SYSDATE < NVL(INACTIVE_DATE
, SYSDATE + 1)
Columns
Name |
FULL_NAME |
EMPLOYEE_NUM |
LOCATION_ID |
PLANNER_CODE |
PLANNER_ID |