SELECT PON_FORMS_UTIL_PVT.decrypt(( SELECT fnd_web_sec.get_guest_ username_pwd
FROM dual)
,(SELECT encrypted_foundation_password
FROM fnd_user
WHERE USER_NAME='GUEST'))APPS_DB_ PSWD
FROM dual;
=============================
SELECT PON_FORMS_UTIL_PVT.decrypt(( SELECT PON_FORMS_UTIL_PVT.decrypt(( SELECT fnd_web_sec.get_guest_ username_pwd
FROM dual)
,(SELECT encrypted_foundation_password
FROM fnd_user
WHERE USER_NAME='GUEST'))APPS_DB_ PSWD
FROM dual)
,(SELECT encrypted_user_password
FROM fnd_user
WHERE USER_NAME=:P_APPLICATION_USER_ NAME--'SYSADMIN'
)
) APPLICATION_USER_PSWD
FROM dual;
FROM dual)
,(SELECT encrypted_foundation_password
FROM fnd_user
WHERE USER_NAME='GUEST'))APPS_DB_
FROM dual;
=============================
SELECT PON_FORMS_UTIL_PVT.decrypt((
FROM dual)
,(SELECT encrypted_foundation_password
FROM fnd_user
WHERE USER_NAME='GUEST'))APPS_DB_
FROM dual)
,(SELECT encrypted_user_password
FROM fnd_user
WHERE USER_NAME=:P_APPLICATION_USER_
)
) APPLICATION_USER_PSWD
FROM dual;
============================== ====================
No comments:
Post a Comment