UPDATE tt_in_summary_monthly_amount_remain
        SET summary_monthly_product_id = (
            SELECT MAX(A.summary_monthly_product_id)
            FROM tt_in_summary_monthly_product A
            WHERE A.session_id = pSessionId AND
                tt_in_summary_monthly_amount_remain.session_id = A.session_id AND
                tt_in_summary_monthly_amount_remain.date_year_month = A.date_year_month AND
                tt_in_summary_monthly_amount_remain.tenant_id = A.tenant_id AND
                tt_in_summary_monthly_amount_remain.ou_bu_id = A.ou_bu_id AND
                tt_in_summary_monthly_amount_remain.product_id = A.product_id AND
                A.doc_type_id IN (311,431,526,521,413,313,560,537) AND
                A.flg_amount = 'MONTHLY_AVG')
    WHERE session_id = pSessionId AND qty = 0 AND gl_amount <> 0;