MATERIALIZED VIEW: APPS.MSC_PHUB_FISCAL_QUARTERS_MV

Source

select
       unique mbp.quarter_start_date                   quarter_start_date,
       'Q' || mbp.quarter_num                                   quarter_name,
       mbp.quarter_num		quarter_num,
       mbp.year_start_date                                     year_start_date,
       mbp.period_year                                            period_year,
       mbp.period_set_name               period_set_name
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')