This view can be used by fact views to derive Forecast dimension foreign keys
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT FD.FORECAST_DESIGNATOR||'-'||FD.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE , FD.FORECAST_DESIGNATOR , FD.ORGANIZATION_ID FROM MRP_FORECAST_DESIGNATORS FD , MTL_PARAMETERS MP , EDW_LOCAL_INSTANCE INST WHERE FD.FORECAST_SET IS NOT NULL AND FD.ORGANIZATION_ID = MP.ORGANIZATION_ID