DROP VIEW LD0V0CCDSJournalnotes
;
CREATE VIEW LD0V0CCDSJournalnotes
AS 
SELECT 
TXT.TEXTID, 
TXT.RUBRIKID, 
TXT.OBJEKTID, 
TXT.CREATEDDAT, 
TXT.CREATEDTIME, 
TXT.CREATEDSIGN, 
TXT.CREATEDROLE,
TXT.STOPDAT,
TXT.OCCURENCEDAT,
TXT.OCCURENCETIME, 
TXT.LOCKDATE,
TXT.SIGNERADDAT,
TXT.FELMARKERAD,
TXT.SIGNERADSIGN,
RUB.NAMN
FROM GA1V0TXT TXT
INNER JOIN GA1V1RUB RUB 
ON TXT.RUBRIKID = RUB.RUBRIKID
WHERE TXT.DELETED = 0
;