MATERIALIZED VIEW: APPS.MSC_PHUB_FISCAL_PERIODS_MV

Source

select
       mbp.sr_instance_id,
       mbp.organization_id,
       mbp.period_name                                        period_name,
       mbp.entered_period_name                        entered_period_name,
       mbp.period_num                                          period_num,
       mbp.start_date                                             start_date,
       mbp.end_date                                              end_date,
       mbp.end_date - mbp.start_date +1  day_count,
       mbp.quarter_start_date                              quarter_start_date,
       mbp.period_set_name                                  period_set_name,
       mbp.DESCRIPTION
from msc_bis_periods mbp
where msc_get_name.org_code(organization_id, sr_instance_id)||':'||mbp.period_set_name = fnd_profile.value('MSC_HUB_PERIOD_SET_NAME')