I got this query from Vasu. This query gives you the current session timezone from Oracle Apps FND views:
SELECT TIMEZONE_CODE
FROM FND_TIMEZONES_VL WHERE UPGRADE_TZ_ID = (SELECT fnd_profile.VALUE('SERVER_TIMEZONE_ID') FROM DUAL)
/
TIMEZONE_CODE
--------------------------------------------------
America/New_York
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps
Wednesday, September 12, 2007
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment