Datadictionary OpenWave 3.1.32

View: vwfrmomgdetailstepubliceren

Schema

public

Owner

waveuser005

Descriptions

View van te publiceren momenten (DROP) bij omgevingzaken (per zaak. per medium per type)

Fields

Rules

Indices

There are no indices for table vwfrmomgdetailstepubliceren

Definition

CREATE VIEW public.vwfrmomgdetailstepubliceren (
   dnkeyomgvergunning,
   dvpubltype,
   ddtriggerdatum,
   ddpublexport,
   dvpublfout,
   dvid,
   dvomsmediatype,
   dvhoofdid)
AS
WITH const AS (
SELECT COALESCE(tbinitialisatie.dfnumber1, 0::double precision)::integer AS val1,
           COALESCE(tbinitialisatie.dvstring, 'ddbesluitdatum'::character
               varying) AS val2
FROM tbinitialisatie
WHERE lower(tbinitialisatie.dvsectie::text) = 'droppublicaties'::text AND
   lower(tbinitialisatie.dvitem::text) = 'omgeving'::text
       )
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Aanvraag'::character varying(20) AS dvpubltype,
   b.ddaanvraag AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('A-W-OL-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'OnLine'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlaanvraagpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddaanvraag AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddaanvraag AND a.dlinwaterschap = 'F'::bpchar AND
           a.dlingemeenteblad = 'F'::bpchar AND a.dlingemeenschap = 'F'::bpchar AND a.dlinprovincie = 'F'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'A'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'OL'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'A'::character varying), 'A'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'A'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Aanvraag'::character varying(20) AS dvpubltype,
   b.ddaanvraag AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('A-W-GB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Gemeenteblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlaanvraagpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddaanvraag AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddaanvraag AND a.dlingemeenteblad = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'A'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'A'::character varying), 'A'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'A'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Aanvraag'::character varying(20) AS dvpubltype,
   b.ddaanvraag AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('A-W-GS-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'BladGemeenschappelijkeRegeling'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlaanvraagpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddaanvraag AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddaanvraag AND a.dlingemeenschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'A'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GS'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'A'::character varying), 'A'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'A'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GS'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Aanvraag'::character varying(20) AS dvpubltype,
   b.ddaanvraag AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('A-W-WB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Waterschapsblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlaanvraagpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddaanvraag AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddaanvraag AND a.dlinwaterschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'A'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'WB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'A'::character varying), 'A'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'A'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'WB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Aanvraag'::character varying(20) AS dvpubltype,
   b.ddaanvraag AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('A-W-PR-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Provinciaalblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlaanvraagpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddaanvraag AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddaanvraag AND a.dlinprovincie = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'A'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'PR'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'A'::character varying), 'A'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'A'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'PR'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Ontwerp'::character varying(20) AS dvpubltype,
   b.ddontwerpbesl AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('O-W-OL-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'OnLine'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlontwerppubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddontwerpbesl AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddontwerpbesl AND a.dlinwaterschap = 'F'::bpchar AND
           a.dlingemeenteblad = 'F'::bpchar AND a.dlingemeenschap = 'F'::bpchar AND a.dlinprovincie = 'F'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'O'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'OL'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'O'::character varying), 'O'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'O'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Ontwerp'::character varying(20) AS dvpubltype,
   b.ddontwerpbesl AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('O-W-GB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Gemeenteblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlontwerppubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddontwerpbesl AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddontwerpbesl AND a.dlingemeenteblad = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'O'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'O'::character varying), 'O'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'O'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Ontwerp'::character varying(20) AS dvpubltype,
   b.ddontwerpbesl AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('O-W-GS-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'BladGemeenschappelijkeRegeling'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlontwerppubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddontwerpbesl AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddontwerpbesl AND a.dlingemeenschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'O'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GS'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'O'::character varying), 'O'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'O'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GS'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Ontwerp'::character varying(20) AS dvpubltype,
   b.ddontwerpbesl AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('O-W-WB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Waterschapsblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlontwerppubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddontwerpbesl AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddontwerpbesl AND a.dlinwaterschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'O'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'WB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'O'::character varying), 'O'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'O'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'WB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Ontwerp'::character varying(20) AS dvpubltype,
   b.ddontwerpbesl AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('O-W-PR-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Provinciaalblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlontwerppubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddontwerpbesl AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddontwerpbesl AND a.dlinprovincie = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'O'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'PR'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'O'::character varying), 'O'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'O'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'PR'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Besluit'::character varying(20) AS dvpubltype,
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('B-W-OL-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'OnLine'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlbesluitpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf <
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) >
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AND a.dlinwaterschap = 'F'::bpchar AND a.dlingemeenteblad =
           'F'::bpchar AND a.dlingemeenschap = 'F'::bpchar AND a.dlinprovincie = 'F'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'B'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'OL'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'B'::character varying), 'B'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'B'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Besluit'::character varying(20) AS dvpubltype,
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('B-W-GB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Gemeenteblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlbesluitpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf <
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) >
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AND a.dlingemeenteblad = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'B'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'B'::character varying), 'B'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'B'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Besluit'::character varying(20) AS dvpubltype,
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('B-W-GS-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'BladGemeenschappelijkeRegeling'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlbesluitpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf <
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) >
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AND a.dlingemeenschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'B'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GS'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'B'::character varying), 'B'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'B'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GS'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Besluit'::character varying(20) AS dvpubltype,
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('B-W-WB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Waterschapsblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlbesluitpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf <
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) >
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AND a.dlinwaterschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'B'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'WB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'B'::character varying), 'B'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'B'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'WB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Besluit'::character varying(20) AS dvpubltype,
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('B-W-PR-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Provinciaalblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlbesluitpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf <
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) >
       CASE
           WHEN (((
       SELECT const.val2
       FROM const
       ))::text) = 'ddbesluitdatum'::text THEN b.ddbesluitdatum
           ELSE b.ddbeschverzonden
       END AND a.dlinprovincie = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'B'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'PR'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'B'::character varying), 'B'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'B'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'PR'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Ingetrokken'::character varying(20) AS dvpubltype,
   b.ddingetrokken AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('I-W-OL-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'OnLine'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlingetrokpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddingetrokken AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddingetrokken AND a.dlinwaterschap = 'F'::bpchar AND
           a.dlingemeenteblad = 'F'::bpchar AND a.dlingemeenschap = 'F'::bpchar AND a.dlinprovincie = 'F'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'I'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'OL'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'I'::character varying), 'I'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'I'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Ingetrokken'::character varying(20) AS dvpubltype,
   b.ddingetrokken AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('I-W-GB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Gemeenteblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlingetrokpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddingetrokken AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddingetrokken AND a.dlingemeenteblad = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'I'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'I'::character varying), 'I'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'I'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Ingetrokken'::character varying(20) AS dvpubltype,
   b.ddingetrokken AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('I-W-GS-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'BladGemeenschappelijkeRegeling'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlingetrokpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddingetrokken AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddingetrokken AND a.dlingemeenschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'I'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GS'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'I'::character varying), 'I'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'I'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GS'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Ingetrokken'::character varying(20) AS dvpubltype,
   b.ddingetrokken AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('I-W-WB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Waterschapsblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlingetrokpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddingetrokken AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddingetrokken AND a.dlinwaterschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'I'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'WB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'I'::character varying), 'I'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'I'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'WB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Ingetrokken'::character varying(20) AS dvpubltype,
   b.ddingetrokken AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('I-W-PR-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Provinciaalblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlingetrokpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddingetrokken AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddingetrokken AND a.dlinprovincie = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'I'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'PR'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'I'::character varying), 'I'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'I'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'PR'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Verlengd'::character varying(20) AS dvpubltype,
   b.ddverdaagdvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('V-W-OL-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'OnLine'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlverlengingpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddverdaagdvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddverdaagdvanaf AND a.dlinwaterschap = 'F'::bpchar AND
           a.dlingemeenteblad = 'F'::bpchar AND a.dlingemeenschap = 'F'::bpchar AND a.dlinprovincie = 'F'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'V'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'OL'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'V'::character varying), 'V'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'V'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Verlengd'::character varying(20) AS dvpubltype,
   b.ddverdaagdvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('V-W-GB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Gemeenteblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlverlengingpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddverdaagdvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddverdaagdvanaf AND a.dlingemeenteblad = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'V'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'V'::character varying), 'V'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'V'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Verlengd'::character varying(20) AS dvpubltype,
   b.ddverdaagdvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('V-W-GS-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'BladGemeenschappelijkeRegeling'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlverlengingpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddverdaagdvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddverdaagdvanaf AND a.dlingemeenschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'V'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GS'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'V'::character varying), 'V'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'V'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GS'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Verlengd'::character varying(20) AS dvpubltype,
   b.ddverdaagdvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('V-W-WB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Waterschapsblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlverlengingpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddverdaagdvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddverdaagdvanaf AND a.dlinwaterschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'V'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'WB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'V'::character varying), 'V'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'V'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'WB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Verlengd'::character varying(20) AS dvpubltype,
   b.ddverdaagdvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('V-W-PR-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Provinciaalblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlverlengingpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddverdaagdvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddverdaagdvanaf AND a.dlinprovincie = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'V'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'PR'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'V'::character varying), 'V'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'V'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'PR'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Opgeschort'::character varying(20) AS dvpubltype,
   b.ddopschortingvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('S-W-OL-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'OnLine'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlopschortpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddopschortingvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddopschortingvanaf AND a.dlinwaterschap = 'F'::bpchar AND
           a.dlingemeenteblad = 'F'::bpchar AND a.dlingemeenschap = 'F'::bpchar AND a.dlinprovincie = 'F'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'S'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'OL'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'S'::character varying), 'S'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'S'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Opgeschort'::character varying(20) AS dvpubltype,
   b.ddopschortingvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('S-W-GB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Gemeenteblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlopschortpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddopschortingvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddopschortingvanaf AND a.dlingemeenteblad = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'S'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'S'::character varying), 'S'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'S'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Opgeschort'::character varying(20) AS dvpubltype,
   b.ddopschortingvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('S-W-GS-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'BladGemeenschappelijkeRegeling'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlopschortpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddopschortingvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddopschortingvanaf AND a.dlingemeenschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'S'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GS'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'S'::character varying), 'S'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'S'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GS'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Opgeschort'::character varying(20) AS dvpubltype,
   b.ddopschortingvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('S-W-WB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Waterschapsblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlopschortpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddopschortingvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddopschortingvanaf AND a.dlinwaterschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'S'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'WB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'S'::character varying), 'S'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'S'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'WB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Opgeschort'::character varying(20) AS dvpubltype,
   b.ddopschortingvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('S-W-PR-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Provinciaalblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlopschortpubliceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddopschortingvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddopschortingvanaf AND a.dlinprovincie = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'S'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'PR'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'S'::character varying), 'S'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'S'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'PR'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Verlengd'::character varying(20) AS dvpubltype,
   b.ddverlengdvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('L-W-OL-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'OnLine'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlverleng2publiceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddverlengdvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddverlengdvanaf AND a.dlinwaterschap = 'F'::bpchar AND
           a.dlingemeenteblad = 'F'::bpchar AND a.dlingemeenschap = 'F'::bpchar AND a.dlinprovincie = 'F'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'L'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'OL'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'L'::character varying), 'L'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'L'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Verlengd2'::character varying(20) AS dvpubltype,
   b.ddverlengdvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('L-W-GB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Gemeenteblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlverleng2publiceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddverlengdvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddverlengdvanaf AND a.dlingemeenteblad = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'L'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'L'::character varying), 'L'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'L'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Verlengd2'::character varying(20) AS dvpubltype,
   b.ddverlengdvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('L-W-GS-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'BladGemeenschappelijkeRegeling'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlverleng2publiceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddverlengdvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddverlengdvanaf AND a.dlingemeenschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'L'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'GS'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'L'::character varying), 'L'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'L'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'GS'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Verlengd2'::character varying(20) AS dvpubltype,
   b.ddverlengdvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('L-W-WB-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Waterschapsblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlverleng2publiceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddverlengdvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddverlengdvanaf AND a.dlinwaterschap = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'L'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'WB'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'L'::character varying), 'L'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'L'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'WB'::text
       ))
   UNION ALL
   SELECT b.dnkey AS dnkeyomgvergunning,
   'Verlengd2'::character varying(20) AS dvpubltype,
   b.ddverlengdvanaf AS ddtriggerdatum,
   d.ddexportdatum AS ddpublexport,
   d.dverror AS dvpublfout,
   (('L-W-PR-'::text || b.dnkey::character varying(20)::text))::character
       varying(27) AS dvid,
   'Provinciaalblad'::character varying(30) AS dvomsmediatype,
   (('W'::character(1)::text || b.dnkey))::character varying(11) AS dvhoofdid
   FROM tbomgvergunning b
    LEFT JOIN tboin oinbg ON b.dnkeyoinbevgez = oinbg.dnkey
    JOIN vwfrmlokaties e ON b.dnkeyperceeladressen = e.dnkeyperceeladressen
    JOIN vwfrmomgkoppublgemzaak a ON b.dnkeysoortomgverg = a.dnkeysoortomgverg
        AND a.dvgemeenteid::text = COALESCE(oinbg.dvgemeenteid, e.dvgemeenteid)::text AND a.dlverleng2publiceren = 'T'::bpchar AND a.ddpublicerenvanaf < b.ddverlengdvanaf AND fn_vandaag((
       SELECT const.val1
       FROM const
       )) > b.ddverlengdvanaf AND a.dlinprovincie = 'T'::bpchar
    LEFT JOIN tbdroppublicaties d ON b.dnkey = d.dnkeyomgvergunningen AND
        d.dvpublicatietype = 'L'::bpchar AND d.dvdossiernr IS NULL AND d.dvmediatype::text = 'PR'::text
   WHERE b.dlzaakpubliceren = 'T'::bpchar AND
       instr(COALESCE(b.dvdroppublicatietypes, 'L'::character varying), 'L'::character varying) > 0 AND b.dnkeyparentverg IS NULL AND NOT (EXISTS (
       SELECT 1
       FROM tbdroppublicaties
       WHERE tbdroppublicaties.dnkeyomgvergunningen = b.dnkey AND
           tbdroppublicaties.dvpublicatietype = 'L'::bpchar AND tbdroppublicaties.dvdossiernr IS NOT NULL AND tbdroppublicaties.dvmediatype::text = 'PR'::text
       ));

COMMENT ON VIEW public.vwfrmomgdetailstepubliceren
IS 'View van te publiceren momenten (DROP) bij omgevingzaken (per zaak. per medium per type)';

COMMENT ON COLUMN public.vwfrmomgdetailstepubliceren.dnkeyomgvergunning
IS 'Primary key van de zaak in tbomgvergunning';

COMMENT ON COLUMN public.vwfrmomgdetailstepubliceren.dvpubltype
IS 'Aanvraag, Verlengd(verdaagd), Verlengd2, Opgeschort, Ingetrokken, Ontwerp, Besluit afhankelijk waardoor het publiceren getriggerd wordt';

COMMENT ON COLUMN public.vwfrmomgdetailstepubliceren.ddtriggerdatum
IS 'Aanvraagdatum, Ontwerpbesluitdatum of Besluit/afgehandeld datum of Verzenddatum of opgeschortvanafdatum of verdaagdvanafdatum of verlengdvanafdatum of ingetrokken datum afhankelijk waardoor het publiceren getriggerd wordt';

COMMENT ON COLUMN public.vwfrmomgdetailstepubliceren.ddpublexport
IS 'Laatste datum dat een poging gedaan is om de zaak onder het publicatietype te publiceren';

COMMENT ON COLUMN public.vwfrmomgdetailstepubliceren.dvpublfout
IS 'Foutcode die door DROP is geretourneerd bij de laatste keer dat een poging gedaan is om de zaak onder het publicatietype te publiceren';

COMMENT ON COLUMN public.vwfrmomgdetailstepubliceren.dvid
IS 'Unieke identfier van de rij door de combinatie van de eerste letter van dvpubltype (A,V,S,O,I, L of B), een hyphen, moduleletter: W, een hyphen mediatype (OL,GB,GS,PR,WB.SC), een hyphen en dnkeyverg';

COMMENT ON COLUMN public.vwfrmomgdetailstepubliceren.dvomsmediatype
IS 'OnLine, Gemeenteblad, BladGemeenschappelijkeRegeling, waterschapblad, provinciaalblad of staatcourant';

COMMENT ON COLUMN public.vwfrmomgdetailstepubliceren.dvhoofdid
IS 'Moduleletter (W) + dnkeyomgvergunning';