Hi,try to get the first lines from KasunBalasooriya and use an select to get the statusSELECT t.username, t.created, t.lock_date, t.account_status, (SELECT active FROM fnd_user where identity = t.username ) Status FROM dba_users t
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.