thanks
Vikas, July 26, 2016 - 7:42 pm UTC
Thanks you! You're correct fiscal_calendar has some dates like begin date and week end date etc. I'm glad to say I figured it out by just using that table only. this query is for 53 weeks.
select distinct week_begin_date, f.week_end_date, trunc((sysdate - f.week_begin_date) /7,0)
from F21.V_HS_FISCAL_CALENDAR f
where f.week_end_date>sysdate-372 and sysdate>=week_begin_date
order by f.week_end_date desc