[Home] [Help]
VIEW: APPS.CHV_SCHEDULERS_ALL_V
Source
View Text - Preformatted
SELECT DISTINCT(HRE.FULL_NAME) , HRE.EMPLOYEE_NUM , HRE.LOCATION_ID , PAA.SCHEDULER_ID FROM PO_ASL_ATTRIBUTES PAA, HR_EMPLOYEES_CURRENT_V HRE WHERE PAA.SCHEDULER_ID = HRE.EMPLOYEE_ID
View Text - HTML Formatted
SELECT DISTINCT(HRE.FULL_NAME)
, HRE.EMPLOYEE_NUM
, HRE.LOCATION_ID
, PAA.SCHEDULER_ID
FROM PO_ASL_ATTRIBUTES PAA
, HR_EMPLOYEES_CURRENT_V HRE
WHERE PAA.SCHEDULER_ID = HRE.EMPLOYEE_ID