CREATE VIEW vwmudetails AS (
 SELECT mu.id,
    mu.name,
    mu.startofweek,
    mu.timezone,
    mu.severealertthresholdminutes,
    mu.adherencetargetpercent,
    mu.adherenceexceptionthresholdseconds,
    mu.nononqueueactivitiesequivalent,
    mu.trackonqueueactivity,
    mu.updated,
    mu.businessunitid AS business_unit_id,
    bu.name AS business_unit_name,
    mu.divisionid AS division_id,
    dd.name AS division_name
   FROM ((mudetails mu
     LEFT JOIN budetails bu ON (((bu.id)::text = (mu.businessunitid)::text)))
     LEFT JOIN divisiondetails dd ON (((dd.id)::text = (mu.divisionid)::text)))
)