Friday, 24 April 2015

How to find Application Instance Login URL same database

SELECT PROFILE_OPTION_VALUE
FROM   FND_PROFILE_OPTION_VALUES
WHERE  PROFILE_OPTION_ID =
       (SELECT PROFILE_OPTION_ID
        FROM FND_PROFILE_OPTIONS
        WHERE PROFILE_OPTION_NAME ='APPS_FRAMEWORK_AGENT')
        AND LEVEL_VALUE=0;

No comments:

Post a Comment