VIEW: APPS.SO_USERS_VAL_V

Source

View Text - Preformatted

SELECT USER_NAME , USER_ID FROM FND_USER WHERE USER_NAME NOT IN ('ANONYMOUS','AUTOINSTALL','INITIAL SETUP', 'FEEDER SYSTEM','CONCURRENT MANAGER', 'STANDALONE BATCH PROCESS') AND NVL(START_DATE,SYSDATE) <= SYSDATE AND NVL(END_DATE, SYSDATE) >= SYSDATE

View Text - HTML Formatted

SELECT USER_NAME
, USER_ID
FROM FND_USER
WHERE USER_NAME NOT IN ('ANONYMOUS'
, 'AUTOINSTALL'
, 'INITIAL SETUP'
, 'FEEDER SYSTEM'
, 'CONCURRENT MANAGER'
, 'STANDALONE BATCH PROCESS')
AND NVL(START_DATE
, SYSDATE) <= SYSDATE
AND NVL(END_DATE
, SYSDATE) >= SYSDATE