-- cek jika dokumen request return goods borrowing sudah di pakai di dokumen return goods borrowing
    IF NOT EXISTS (
        SELECT a.request_delivery_goods_borrowing_id FROM in_balance_req_delivery_goods_borrowing a
        INNER JOIN in_request_delivery_goods_borrowing b ON a.request_delivery_goods_borrowing_id = b.request_delivery_goods_borrowing_id
        INNER JOIN in_inventory c ON b.ref_id = c.inventory_id AND b.ref_doc_type_id = c.doc_type_id
        INNER JOIN in_inventory_borrow d ON c.inventory_id = d.inventory_id
        INNER JOIN in_inventory_borrow_balance_item e ON c.ou_from_id = e.ou_id AND c.inventory_id = e.inventory_id
        INNER JOIN m_partner_address f ON a.partner_ship_address_id = f.partner_address_id
        WHERE c.tenant_id = pTenantId
            AND c.ou_from_id = vOuId
            AND e.status_item = vStatusRelease
            AND ((e.qty_do-e.qty_return)-e.qty_sales) > 0
            AND c.doc_type_id = vDocTypeDGB

        GROUP BY a.request_delivery_goods_borrowing_id
    ) THEN
        RAISE EXCEPTION 'Request Return Goods Borrowing Already Used in Return Goods Borrowing';
    END IF;