Oracle ERP - GL Calendar
SELECT
 period_year f_year,
 period_num  month_No,
 entered_period_name  f_month,
 quarter_num  f_qtr,
 TO_CHAR(start_date,'mm/dd/yyyy') f_start,
 TO_CHAR(end_date,'mm/dd/yyyy')  f_end,
 (end_date - start_date)+1 fm_days,
 SUM((end_date - start_date)+1) OVER (ORDER BY period_num) cfy_days,
 adjustment_period_flag
FROM  gl_periods
Where period_set_name = 'Fiscal Calendar'   -- value may be different 
AND   period_year = &i_yyyy;

Refer: Gregorian Calendar

Oracle registered trademark of Oracle Corporation.

Last Revised On: August 11, 2014

  7619