Блог

 UPDATE TMP_OP_USPORTCALLS_RPT 
SET CARGO_QTY =  ( 
    SELECT A.CARGO_QUANTITY FROM ( 
        SELECT CASE WHEN (SUM(NVL(QUANTITY,0))) > 0 THEN ROUND(SUM(NVL(QUANTITY,0))) END AS CARGO_QUANTITY 
        FROM OP_POSITION_CARGO 
        WHERE COMPANY_ID = 2 
        AND SHIP_ID = '380' 
        AND COMMODITY_ID = 816 
        AND KEY_POSITION = (
            SELECT KEY_POSITION 
            FROM OP_POSITION_DETAILS 
            WHERE COMPANY_ID = 2 AND SHIP_ID = '380' AND VOYAGE_NO = 152 
            AND KEY_POSITION = 800892 
            AND EVENT_ID = ( 
                SELECT EVENT_ID    
                FROM MA_EVENT 
                WHERE COMPANY_ID = 2 AND UPPER(EVENT_NAME) LIKE 'LOAD%'
            ) 
        ) 
        GROUP BY KEY_POSITION, COMMODITY_ID,UNIT_CODE 
    ) A) 
WHERE COMPANY_ID = 2 AND SHIP_ID = '380' AND VOYAGE_NO = 152 
AND KEY_POSITION = 800892 AND COMMODITY_ID = 816 AND QUERY_ID = '1476272548543'
  

Это мой запрос, кто-нибудь может сказать, где я допустил ошибку