[Home] [Help]
View: RCV_RECEIVERS_UNORDERED_V
View Text
SELECT DISTINCT HRE.EMPLOYEE_ID
, HRE.FULL_NAME
, RT.ORGANIZATION_ID
FROM HR_EMPLOYEES_ALL_V HRE
, RCV_TRANSACTIONS RT
WHERE RT.EMPLOYEE_ID = HRE.EMPLOYEE_ID
AND RT.TRANSACTION_TYPE = 'UNORDERED'
Columns
Name |
EMPLOYEE_ID |
FULL_NAME |
ORGANIZATION_ID |