CREATE VIEW z_vwcallabandonedsummary AS (
 SELECT det.conversationid,
    det.conversationstartdate,
    (det.conversationstartdate AT TIME ZONE 'Australia/Sydney'::text) AS conversationstartdateltc,
    det.conversationenddate,
    (det.conversationenddate AT TIME ZONE 'Australia/Sydney'::text) AS conversationenddateltc,
    det.segmentstartdate,
    (det.segmentstartdate AT TIME ZONE 'Australia/Sydney'::text) AS segmentstartdateltc,
    det.segmentenddate,
    (det.segmentenddate AT TIME ZONE 'Australia/Sydney'::text) AS segmentenddateltc,
    det.convtosegmentendtime AS totalcalltime,
    det.segmenttime AS queuetime,
    det.ani,
    det.dnis,
    det.queueid,
    que.name AS queuename,
    det.purpose,
    det.segmenttype,
    det.disconnectiontype
   FROM (detailedinteractiondata det
     LEFT JOIN queuedetails que ON (((det.queueid)::text = (que.id)::text)))
  WHERE (((det.segmenttype)::text = ANY ((ARRAY['delay'::character varying, 'Interact'::character varying, 'alert'::character varying, 'ivr'::character varying])::text[])) AND ((det.purpose)::text = ANY ((ARRAY['acd'::character varying, 'ivr'::character varying])::text[])) AND ((det.disconnectiontype)::text = 'peer'::text) AND (det.conversationenddate = det.segmentenddate))
)