Source view:

CREATE VIEW "VW_CHECK_COMPLETED_JOBS" AS
SELECT JJ.OrderID, (
SELECT count(orderid) FROM jobtracking JT
INNER JOIN jobtrackingdetails JTD
ON JTD.orderid=JT.orderid
WHERE JTD.status < 2 AND JTD.orderid=JJ.orderid 
GROUP BY orderid
)
AS NotProcessed
FROM jobtracking JJ

View that causes AV:

CREATE VIEW "VW_COMPLETED_JOBS" AS
SELECT OrderID, OrderLineID, SectionID, ProcessedOn, UserID, Status FROM VW_CHECK_COMPLETED_JOBS CCJ
INNER JOIN jobtrackingdetails JTD
ON JTD.orderid=CCJ.orderid
WHERE NotProcessed is null