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