DBA Data[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