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