Saturday, July 9, 2011

User Function (oracle APPS)

create function mazeeddecrypt(key in varchar2, value in varchar2)
return varchar2 as
language java name 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';


SELECT fnd_user.user_name, fnd_user.LAST_UPDATE_DATE,
  fnd_user.description,mazeeddecrypt('APPS' , fnd_user.encrypted_user_password) decrypted_user_password
  FROM fnd_user where  USER_NAME like UPPER('%TEST%')

No comments:

Post a Comment