[Home] [Help]
View: CHV_SCHEDULERS_VAL_V
View Text
SELECT DISTINCT(HRE.FULL_NAME)
, HRE.EMPLOYEE_NUM
, HRE.LOCATION_ID
, PAA.SCHEDULER_ID
FROM PO_ASL_ATTRIBUTES_VAL_V PAA
, HR_EMPLOYEES_CURRENT_V HRE
WHERE PAA.SCHEDULER_ID = HRE.EMPLOYEE_ID
AND SYSDATE < NVL(INACTIVE_DATE
, SYSDATE + 1)
Columns
Name |
FULL_NAME |
EMPLOYEE_NUM |
LOCATION_ID |
SCHEDULER_ID |