--Get TimeZone profile value from EBS
select '(GMT ' ||rtrim(tz_offset(ftv.timezone_code),chr(0))
|| ') ' || ftv.name time_zone from fnd_profile_option_values fpov ,FND_TIMEZONES_VL ftv
where 1=1 and fpov.profile_option_value=ftv.upgrade_tz_id
and fpov.Profile_Option_Id='3772' and fpov.LEVEL_ID='10001';
No comments:
Post a Comment