MATERIALIZED VIEW: APPS.MSC_PHUB_FISCAL_YEARS_MV

Source

select unique mbp.year_start_date                           year_start_date,
            mbp.period_year                                 period_year,
	    mbp.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')