CREATE VIEW View_Fault
AS 
SELECT X.*, (
        SELECT COUNT(1)
        FROM RunFault B
        WHERE B.DelayTypeID = 2
            AND B.LineID = X.LineID
            AND to_char(B.faultdate, 'yyyyMM') = X.AppMonth
        ) AS DelayFiveSum
FROM (
    SELECT A.AppMonth, A.LineID, SUM(OffLines) AS OffLineSum, SUM(DepDelay + ArrDelay) AS NormalSum, SUM(SkipLine) AS SkipLineSum
        , SUM(Clear) AS ClearSum
    FROM View_FaultALL A
    WHERE nvl(IsDelete, 0) = 0
        AND Status = 1
    GROUP BY A.AppMonth, A.LineID
) X