Hi Team,
we are trying to fetch timezone id based on abbrev .
In hz_timezones_vl we had coulmn which used to hold abbreviation
select * from apps.hz_timezones_vl where GLOBAL_TIMEZONE_NAME='PST'
But in Fnd_timezones_vl we dont have proper column which will hold the abbreviation based on that we will fetch timezone code . We need to use V$timezone_names , there also we are seeing difference .
SELECT distinct TIMEZONE_CODE
FROM V$TIMEZONE_NAMES,fnd_timezones_vl where
TIMEZONE_CODE=tzname
and TZABBREV='PST'
Could you please if any function we have to fetch timezone id based on abbreviation
Thanks,
Ravi.