CREATE VIEW vwofferedforecast AS (
 SELECT DISTINCT ofd.keyid,
    ofd.businessunitid,
    bu.name AS "BUSINESSUNITNAME",
    ofd.scheduleid,
    scd.description AS "SCHEDULEDESC",
    ofd.planninggroup AS "PLANNINGGROUPID",
    pgd.businessunitid AS "PLANNINGGROUP_BUSINESSUNITID",
    pgd.name AS "PLANNINGGROUPNAME",
    ofd.shorttermforecastid,
    ofd.startdate,
    ofd.startdateltc,
    ofd.weekdate,
    ofd.week,
    ofd.avghandleperinterval,
    ofd.offeredperinterval,
    ofd.canuseforscheduling,
    ofd.updated
   FROM (((offeredforecastdata ofd
     LEFT JOIN vwbudetails bu ON (((bu.id)::text = (ofd.businessunitid)::text)))
     LEFT JOIN scheduledetails scd ON (((scd.scheduleid)::text = (ofd.scheduleid)::text)))
     LEFT JOIN planninggroupdetails pgd ON (((pgd.id)::text = (ofd.planninggroup)::text)))
)