VIEW: APPS.AP_USERS_V

Source

View Text - Preformatted

SELECT distinct to_char(U.user_id) user_id, U.user_name FROM fnd_user U, ap_invoices I WHERE I.created_by = U.user_id ORDER BY U.user_name

View Text - HTML Formatted

SELECT DISTINCT TO_CHAR(U.USER_ID) USER_ID
, U.USER_NAME
FROM FND_USER U
, AP_INVOICES I
WHERE I.CREATED_BY = U.USER_ID ORDER BY U.USER_NAME