[Home] [Help]
VIEW: APPS.RCV_RECEIVERS_UNORDERED_V
Source
View Text - Preformatted
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'
View Text - HTML Formatted
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'